topic Re: SAS/Access Interface for ODBC in Administration and Deployment

SAS/Access Interface for ODBC

Aasth — Wed, 08 Apr 2020 17:37:10 GMT

Hi,

I am getting the following error when trying to connect to ODBC table:

ERROR: The ODBC engine cannot be found.

ERROR: Error in the LIBNAME statement.

I ran the proc setinit; run; program and see the following listed:

---Base SAS Software 27FEB2021
---SAS/STAT 27FEB2021
---SAS/GRAPH 27FEB2021
---SAS/ETS 27FEB2021
---SAS/Secure 168-bit 27FEB2021
---SAS/Secure Windows 27FEB2021
---SAS Enterprise Guide 27FEB2021
---SAS/ACCESS Interface to DB2 27FEB2021
---SAS/ACCESS Interface to PC Files 27FEB2021
---SAS/ACCESS Interface to ODBC 27FEB2021
2 The SAS System 09:41 Wednesday, April 8, 2020

---SAS Workspace Server for Local Access 27FEB2021
---High Performance Suite 27FEB2021

However, when I run the program

proc product_status;

run;

This is the output :

For Base SAS Software ...
Custom version information: 9.4_M4
Image version information: 9.04.01M4P110916
For SAS/STAT ...
Custom version information: 14.2
For SAS/GRAPH ...
Custom version information: 9.4_M4
For High Performance Suite ...
Custom version information: 2.2_M5
For SAS/ACCESS Interface to DB2 ...
Custom version information: 9.4_M2

I do not see SAS/Access for ODBC listed. Does this mean I have to reinstall SAS all over again? Please help

Thanks,

Re: SAS/Access Interface for ODBC

SASKiwi — Wed, 08 Apr 2020 20:27:01 GMT

It means SAS/ACCESS to ODBC is not installed on your computer even though it is licensed. You can install this as an additional product without having to reinstall SAS completely. The SAS installation wizard has an option for this.

Re: SAS/Access Interface for ODBC

Aasth — Thu, 09 Apr 2020 15:55:23 GMT

Thank you but when we run proc_product status; on SAS Enterprise guide we don’t see it being listed yet:

For Base SAS Software ...

Custom version information: 9.4_M6

Image version information: 9.04.01M6P110718

For SAS/GRAPH ...

Custom version information: 9.4_M6

For SAS OLAP Server ...

Custom version information: 9.4

For SAS Integration Technologies ...

Custom version information: 9.4_M6

For SAS/Secure 168-bit ...

Custom version information: 9.41_M3

For SAS/ACCESS Interface to DB2 ...

Custom version information: 9.4_M2

2 The SAS System 06:45 Thursday, April 9, 2020

For SAS/ACCESS Interface to Microsoft SQL Server ...

Custom version information: 9.44

NOTE: PROCEDURE PRODUCT_STATUS used (Total process time):

real time 0.01 seconds

cpu time 0.02 seconds

However, it is listed when run on Base SAS but we get the following error when trying to connect:

[Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior

that the application requested (see SQLSetEnvAttr).

Please let us know what might be missing for this component to work as expected.

Re: SAS/Access Interface for ODBC

SASKiwi — Thu, 09 Apr 2020 22:18:32 GMT

Your Enterprise Guide uses a different version of SAS - 9.4_M6 - SAS/ACCESS to ODBC needs to be installed there too.