ERROR: The ODBC engine cannot be found.

[ajmiao]

Hi,

I am getting this error '[tt]ERROR: The ODBC engine cannot be found[/tt]' and am wondering if anyone has ideas of why this is happening? I'm new to SAS, and am trying to run code that I've received from someone else. Here is my output log:

[tt]
%LET MDBFILE='c:\Program Files\data4.mdb';
%LET FILENAME='c:\Program Files\tables5.txt';
Libname data4 'c:\Program Files\data4';

NOTE: Libref data4 was successfully assigned as follows:
Engine: V9
Physical Name: c:\Program Files\data4

Filename path2 'c:\Program Files\data4\scoring';
Missing S I N D;
Options noerrorabend;

Proc sql;
Connect to odbc ("dsn=MS Access 97 Database"; DBQ=&MDBFILE");

ERROR: The ODBC engine cannot be found.
ERROR: A Connection to the odbc DBMS is not currently supported, or is not installed at your site.
[/tt]

I found an old similar (closed) thread on this forum where someone suggested running the PROC SETINIT to see if the SAS ODBC engine is licensed. I ran a PROC SETINIT command, and got the following output (I removed the site name and site number):

[tt]
proc setinit; run;

NOTE: PROCEDURE SETINIT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

Original site validation data
Site name: 'xxxx'.
Site number: xxxx.
Expiration: 14AUG2010.
Grace Period: 45 days (ending 28SEP2010).
Warning Period: 45 days (ending 12NOV2010).
System birthday: 07SEP2009.
Operating System: W32_WKS .
Product expiration dates:
---Base Product 14AUG2010
---SAS/STAT 14AUG2010
---SAS/GRAPH 14AUG2010
---SAS Workspace Server for Local Access 14AUG2010
[/tt]

Does anyone have ideas about what may be causing this error or how I can troubleshoot it?

A couple other thing I should add: The SAS ODBC Driver is installed. When I look for Drivers under Data Sources on my computer, 'SAS' and 'SAS Table Server' are both present. Also, the 'MS Access 97 Database' Data Source Name has been entered/added.

Thanks for any help!
am

 

[klaz2002]

At first glance it seems you don't have the license for Access on your computer. You need to contact SAS and find out if your site has the license but failed to load that part onto your machine.
Klaz