ERROR: The ODBC engine cannot be found.

[ifm]

Hi all

I am working the first time with SAS, so my question might be trivial.

We are running a WIN7 client and using SAS pretty much only for data convertion.

To speed things up we set up SAS on some WIN10 clients with the following software installed:

• SAS 9.4 (fully licenced)
• Microsoft SQL Server Management Studio 2014

We then try to run the following command:

libname odbclib odbc noprompt="dsn=sql1;Trusted_Connection=yes"
schema=DBO;

Resulting in the following:

ERROR: The ODBC engine cannot be found.
ERROR: Error in the LIBNAME statement.

The "sql1" is a correctly configured connection in the Microsoft ODBC Administrator with the driver "SQL Server".

I am by no means familiar with the program.

The person using it instructed me to install the software mentioned above.

From my point of view there are no configuration differences between the two systems other than the fact that the working enviroment of the collegue runs on WIN7.

I searched in the internet a lot for the error message and I also updated the ODBC drivers.

Can you guys help me?

Thanks in advance.

[SASKiwi · Accepted solution]

You error indicates that the SAS product providing ODBC, SAS/ACCESS to ODBC, is not installed. Please run - proc product_status; run - to confirm what you have installed.

[ifm]

15   proc product_status ALLINFO; run;

For Base SAS Software ...
   Custom version information: 9.4_M1
   Image version information: 9.04.01M1P120413
For SAS/STAT ...
   Custom version information: 13.1
For SAS/GRAPH ...
   Custom version information: 9.4_M1
For SAS/ETS ...
   Custom version information: 13.1
For SAS/FSP ...
   Custom version information: 9.4_M1
For SAS/AF ...
   Custom version information: 9.4_M1
For SAS/QC ...
   Custom version information: 13.1
For SAS/ASSIST ...
   Custom version information: 9.4
   Image version information: 9.04.01M0P061913
For SAS/CONNECT ...
   Custom version information: 9.4_M1
For SAS/EIS ...
   Custom version information: 9.4
   Image version information: 9.04.01M0P061913
For High Performance Suite ...
   Custom version information: 2.2
   Image version information: 9.04.01M0P022614
For SAS/ACCESS Interface to DB2 ...
   Custom version information: 9.4_M1
NOTE: PROCEDURE PRODUCT_STATUS used (Total process time):
      real time           0.18 seconds
      cpu time            0.01 seconds

Thanks for the answer.

That's the output I get.

Nothing about "ODBC" or SAS/ACCESS to ODBC".

-> How/Where can I install there components?

Are they named differently in the SAS Deployment Wizard?

[ifm]

Ok seems like I fixed it.

After the third complete reinstallation it works now.

I think we installed the parts in the wrong order in the first place.

The following procedure made it work:

1. Installing the SAS Software Depot (default values, only for windows, only english)

2. Installing SAS Foundation and Related Software (default values) + adding ODBC Drivers

I think if you try to add certain parts of subfunctions after installing the main function it just doesn't work / install properly.

Thanks for the help anyways!

[SASKiwi]

Cool. Navigating the Deployment Wizard can be tricky. SAS/ACCESS to ODBC is definitely in the Foundation install.