BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
GreggB
Pyrite | Level 9

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
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.

View solution in original post

6 REPLIES 6
Reeza
Super User
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
Pyrite | Level 9

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
Super User
You should see the following:

For SAS/ACCESS Interface to ODBC ...

So SAS doesn't currently see it as installed.
GreggB
Pyrite | Level 9

Suggestions? I've never had this module before.

Reeza
Super User
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
Ammonite | Level 13 VDD
Ammonite | Level 13

did you create an ODBC reference on the workstation?

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 1797 views
  • 0 likes
  • 3 in conversation