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.
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.
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.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.