01-09-2012 05:09 PM
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.
01-19-2012 09:44 AM
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.
01-19-2012 03:29 PM
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.