Architecting, installing and maintaining your SAS environment

SAS/Access Interface to Oracle, SASORA error

Reply
New Contributor
Posts: 2

SAS/Access Interface to Oracle, SASORA error

If a user right clicks and says on a sas file "Open with SAS 9.2" and tries to run some SAS code, it fails with:

ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded.

ERROR: Image SASORA found but not loadable. 

ERROR: A Connection to the oracle DBMS is not currently supported, or is not installed at your site.

But if the same user opens SAS directly, chooses File --> Open --> "mycode.sas"  it runs.

Super Contributor
Posts: 356

SAS/Access Interface to Oracle, SASORA error

Might help if you show the code....

Trusted Advisor
Posts: 2,115

Re: SAS/Access Interface to Oracle, SASORA error

Sounds like an installation issue.  I am assuming that you are using windows.  You need to look at the call that windows runs to see the differences.  Tech support can walk you through this.

In XP, one "my computer" and select tools --> file options --> sas

then Advanced and single click on 'open with SAS 9.2' and edit to see the call for the open.

You can do a similar thing with however you initially execute SAS in the second scenario.

My guess is that it is picking up different configuration files.

Trusted Advisor
Posts: 1,301

SAS/Access Interface to Oracle, SASORA error

You need to have the Oracle Client software installed on the machine that you are trying to use to access the DMBS from through SAS.  If SAS cannot find these binaries it will not work.  Also you need to make sure that the machine has knowledge of the proper tnsping information.

Ask a Question
Discussion stats
  • 3 replies
  • 1869 views
  • 0 likes
  • 4 in conversation