SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

ERROR: The ODBC engine cannot be found.

Accepted Solution Solved
Reply
New Contributor ifm
New Contributor
Posts: 3
Accepted Solution

ERROR: The ODBC engine cannot be found.

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.


Accepted Solutions
Solution
‎01-25-2018 07:16 AM
Super User
Posts: 3,856

Re: ERROR: The ODBC engine cannot be found.

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.

View solution in original post


All Replies
Solution
‎01-25-2018 07:16 AM
Super User
Posts: 3,856

Re: ERROR: The ODBC engine cannot be found.

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.

New Contributor ifm
New Contributor
Posts: 3

Re: ERROR: The ODBC engine cannot be found.

[ Edited ]
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?

New Contributor ifm
New Contributor
Posts: 3

Re: ERROR: The ODBC engine cannot be found.

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!

Super User
Posts: 3,856

Re: ERROR: The ODBC engine cannot be found.

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 901 views
  • 1 like
  • 2 in conversation