topic Re: SAS/ACCESS Interface to ODBC in SAS Programming

SAS/ACCESS Interface to ODBC

GreggB — Mon, 05 Nov 2018 16:58:39 GMT

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.

Re: SAS/ACCESS Interface to ODBC

Reeza — Mon, 05 Nov 2018 17:14:26 GMT

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.

Re: SAS/ACCESS Interface to ODBC

GreggB — Mon, 05 Nov 2018 17:39:58 GMT

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

Re: SAS/ACCESS Interface to ODBC

VDD — Mon, 05 Nov 2018 17:48:24 GMT

did you create an ODBC reference on the workstation?

Re: SAS/ACCESS Interface to ODBC

Reeza — Mon, 05 Nov 2018 18:04:53 GMT

You should see the following:

For SAS/ACCESS Interface to ODBC ...

So SAS doesn't currently see it as installed.

Re: SAS/ACCESS Interface to ODBC

GreggB — Mon, 05 Nov 2018 18:07:53 GMT

Suggestions? I've never had this module before.

Re: SAS/ACCESS Interface to ODBC

Reeza — Mon, 05 Nov 2018 18:09:12 GMT

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.