11-20-2013 09:20 PM
Did not know where to put this post so I am writing it here
I have SQL Developer 4 (32/64) and i SAS 9.2(32bits) and i am trying to connect them .I am licensed to SAS/ACCESS to Oracle
libname oralib oracle user=system password=xxxxx
The "xe" is from the tnsname.ora file (SERVICE_NAME = XE)
and this is the error i am getting.
ERROR: Error in the LIBNAME statement.
Google could not help me. Anyone with the same experience?
11-20-2013 11:32 PM
I found 14 SAS Support notes on your problem searching on the text "ORACLE cannot be loaded & Image SASORA found but not loadable" here: https://support.sas.com/.
I suggest you do the same and work through the notes to see if any might help you.
11-20-2013 11:50 PM
i had already tried half of the suggestions.Who knows maybe it s cuz i have sas (32) on a windows 64.
Thanks for the suggestion though.
Hey SASKiwi,can you please try to see if you can open "Oracle Patch Number 5059238" on this site:
it s not opening for me
11-20-2013 11:57 PM
and i do have the parentheses in this path C:\Program Files\SAS\SASFoundation\9.2 (32-bit).
maybe that causes the issue but i cant open this patch number they have provided.Went on Oracle.com and could not find there either :smileycry:
11-21-2013 05:27 PM
Oracle SQL Developer does not provide the Oracle client that you need for the SAS Access engine to work. You can do all kinds of cool things with SQL Developer, but you will still need the Oracle client.
11-21-2013 05:59 PM
i have an oracle server that my sql developer as a client functions with but i thought i could use that client to have SAS access that server. So now i am in the process of installing Oracle Client 11. Am i doing right?
I am not an oracle person
11-21-2013 06:46 PM
so i am following instructions that i found on sas.com
11-21-2013 07:01 PM
Perhaps you should put in a ticket with SAS Technical Support. It appears you are licensed for SAS Access to Oracle, but the requisite dll seems to be missing. This could be caused by lots of different things, I suppose: incomplete install, install from the wrong software depot, accidental file deletion, so on and so on.