Hello everyone,

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.

More Moshood Agba Bakare's questions See All
Similar questions and discussions