topic Re: SAS/Access Interface to Oracle, SASORA error in Administration and Deployment

SAS/Access Interface to Oracle, SASORA error

foertter — Mon, 09 Jan 2012 22:09:18 GMT

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.

SAS/Access Interface to Oracle, SASORA error

twocanbazza — Tue, 10 Jan 2012 03:01:42 GMT

Might help if you show the code....

Re: SAS/Access Interface to Oracle, SASORA error

Doc_Duke — Thu, 19 Jan 2012 14:44:37 GMT

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.

SAS/Access Interface to Oracle, SASORA error

FriedEgg — Thu, 19 Jan 2012 20:29:05 GMT

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.

Re: SAS/Access Interface to Oracle, SASORA error

mbakare — Mon, 03 Dec 2018 13:49:58 GMT

I am having similar problem. I can't connect to oracle database 11g xe edition from SAS. With this version of oracle, do we need to install oracle client as well?

Re: SAS/Access Interface to Oracle, SASORA error

SASKiwi — Mon, 03 Dec 2018 19:06:48 GMT

Oracle's SQL*Net software needs to be installed on the same machine you are running SAS on.

Re: SAS/Access Interface to Oracle, SASORA error

mbakare — Mon, 03 Dec 2018 19:53:07 GMT

Thanks for the response. I just discovered I am using 32-bit version of SAS? Does it matter? Could that be a problem why I was unable to connect to oracle?

Re: SAS/Access Interface to Oracle, SASORA error

SASKiwi — Mon, 03 Dec 2018 20:06:30 GMT

I suspect the bitness of SAS and the Oracle client software should match. The other thing is ensuring that SQL PLus is working correctly before trying SAS.

Re: SAS/Access Interface to Oracle, SASORA error

mbakare — Mon, 03 Dec 2018 20:09:53 GMT

my command sqlplus works perfectly. Could you please send me the link to download SQL *NET software?

Re: SAS/Access Interface to Oracle, SASORA error

SASKiwi — Tue, 04 Dec 2018 03:33:22 GMT

I suggest you talk to your Oracle DBA to source the correct software - I'm assuming here you are connecting to a remote Oracle database.

Re: SAS/Access Interface to Oracle, SASORA error

mbakare — Tue, 04 Dec 2018 03:39:36 GMT

I am not connecting to remote oracle database. I have both Oracle 11g database XE and 32-bit SAS 9.4 installed on a single system running window 10 64-bit Operating system.

Re: SAS/Access Interface to Oracle, SASORA error

SASKiwi — Tue, 04 Dec 2018 07:32:14 GMT

OK, in that case please post the SAS log of the program you are using to test a connection to Oracle, including any notes and errors.