topic SAS EG Query Getting Below ERROR: CLI cursor extended fetch error in SAS Programming

SAS EG Query Getting Below ERROR: CLI cursor extended fetch error

amitbjambhulkar — Fri, 21 Jun 2024 08:29:48 GMT

Hi,

Getting below error in SAS Query. Please let me know if anyone know how to resolve this issue.

ERROR: CLI cursor extended fetch error: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1408F10B:SSL
routines:SSL3_GET_RECORD:wrong version number]

Thanks,

Amit

Re: SAS EG Query Getting Below ERROR: CLI cursor extended fetch error

s_lassen — Sun, 23 Jun 2024 13:06:51 GMT

This error is probably not related to SAS or even to SQL server, it is probably in the HTTP setup - the may be that a request is made in HTTP, but the server expects a HTTPS query.

What does your libname statement for ODBC look like?

Re: SAS EG Query Getting Below ERROR: CLI cursor extended fetch error

Sajid01 — Sun, 23 Jun 2024 14:07:59 GMT

Hello @amitbjambhulkar
This has something to do with your configurations of your local installation. The appropriate approach would be to approach the SAS Administrator at your place.

Re: SAS EG Query Getting Below ERROR: CLI cursor extended fetch error

amitbjambhulkar — Mon, 24 Jun 2024 07:03:05 GMT

libname GUS odbc dsn=SHDRGUS user=s_sas password='XXX' schema=dbo

Re: SAS EG Query Getting Below ERROR: CLI cursor extended fetch error

amitbjambhulkar — Mon, 24 Jun 2024 07:03:47 GMT

Okay. Thanks!!