topic The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA in SAS Procedures

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

deleted_user — Fri, 02 Jan 2009 22:27:15 GMT

1 LIBNAME emis ORACLE PATH=emis SCHEMA=emis USER=emis PASSWORD=XXXXXXXXXXXXXXXXXX ;
ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not
loadable.
ERROR: Error in the LIBNAME statement.

I am getting this Error When try to Import the Oracle table.

SAS running on WIN 2008
Oracle Client : 10g Release 2 (10.2) for Microsoft Windows (32-Bit)

Any Help Will be Highly Appreciated.

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

sbb — Sat, 03 Jan 2009 03:40:23 GMT

The SAS support website http://support.sas.com/ has this reference which may be useful:

Usage Note 11728: SAS 9 of the SAS/ACCESS Interface to Oracle needs an Oracle 64-bit client installation
http://support.sas.com/kb/11/728.html

Scott Barry
SBBWorks, Inc.

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

deleted_user — Sun, 04 Jan 2009 17:25:43 GMT

Thank you SBB, It is working now. The problem is i did not install the right Oracle Client.
Thanks.