Unable to connect to oracle 11g xe database from SAS

[mbakare]

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

[LinusH]

Have you fulfilled the post install configuration, including SQL*NET client and editing the tnsnames.ora file?

I think the error message implies that there is a problem with the installation/configuration (or even license?).

[mbakare]

I was able to create and connect to database through command line sql-plus and oracle sql developer.Does it mean SQL * NET is still required? How do I edit tnsnames.ora? What do I need to edit?

[Tom]

---

@mbakare wrote:
I was able to create and connect to database through command line sql-plus and oracle sql developer.Does it mean SQL * NET is still required? How do I edit tnsnames.ora? What do I need to edit?

---

Sounds like you have Oracle tools installed properly to use.  Make sure that they are actually installed properly for SAS/Access to Oracle to work.

Also make sure that SAS is running on the same machine that you are running those other program from.  With interfaces such as SAS Enterprise Guide and SAS/Studio the server that is actually running SAS might not be your local machine.

[mbakare]

Thanks for the quick response. I run both SAS 9.4 and Oracle database 11g xe edition on a single window 10 64-bit enterprise edition. Do I need to install oracle client for me to connect to Oracle database 11g xe  from SAS? My oracle runs perfectly both in sqlplus and oracle sql developer likewise the SAS. The big challenge is to connect database from SAS

Please let me know if oracle database 11g xe edition requires oracle client for me to connect it from SAS.

Thanks