SAS/ACCESS Interface to ODBC

[GreggB]

I just downloaded and installed SAS/ACCESS Interface to ODBC. I'm running SAS 9.4 on Windows 64 bit machine. 

My task is to connect to a  live oracle database (known as Powerschool). 

The IT dept gave me this info (changed to nonsense in this post):

datasrc=fakesource user=fakeuser password=fakepw;

SAS LOG

libname mydblib odbc datasrc=fakesource user=fakeuser password=XXXXXXXXXX;

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

[Reeza]

Run the following to check if it's installed correctly.

proc product_status;run;

If you don't see ODBC in the list its not installed correctly.

[GreggB]

10 proc product_status;run;

For Base SAS Software ...
Custom version information: 9.4_M5
Image version information: 9.04.01M5P090617
For SAS/STAT ...
Custom version information: 14.3
For SAS/GRAPH ...
Custom version information: 9.4_M5
For High Performance Suite ...
Custom version information: 2.2_M6
For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.4_M5
NOTE: PROCEDURE PRODUCT_STATUS used (Total process time):
real time 0.17 seconds
cpu time 0.03 seconds

[Reeza]

You should see the following:

For SAS/ACCESS Interface to ODBC ...

So SAS doesn't currently see it as installed.

[GreggB]

Suggestions? I've never had this module before.

[Reeza · Accepted solution]

This also assumes you restarted your machine after the updates and such to allow the new software and licensing to be pushed through. Otherwise, contact SAS Tech support.

[VDD]

did you create an ODBC reference on the workstation?