Hello everyone, Please I need your help to connect to oracle database from SAS 9.4. I had successfully installed oracle database 11g XE edition and SAS 9.4 version on a system running on windows 10 Enterprise. I was able to create database through sql-plus or oracle sql developer. I have all required SAS components such as SAS\ACCESS to ORACLE and SAS\ACCESS to ODBC installed. I had error while trying to connect to database from SAS using libname myora oracle user='Bakare' password='Agbaman' path='XE'; the error message I got is below: 2 libname myora oracle user='Moshood' passoword='Agbaman' path='XE' ; ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not loadable.. Please make sure Oracle environment is set correctly. Look in the install/Config doc for additional info for your platform. Other possible reasons - incomplete Oracle client install, 32/64-bit mismatch between Oracle client & SAS, incorrect Oracle client version(Oracle client must match the version picked during post-install process), incompatible sasora for your OS or its attribs don't permit SAS to load it. ERROR: Error in the LIBNAME statement. Thanks
... View more