Oracle database not connecting with SAS Enterprise guide 4.2

Reply
Contributor
Posts: 30

Oracle database not connecting with SAS Enterprise guide 4.2

Dear All,

I am using oracle database. When I am trying to connect SAS with oracle (client) Schema then I get the Error. Although when we try to connect with sqlplus* the its connecting. So can any one  please suggest something about this.

code:

libname  gj oracle user=ahmd password=ahmd path=sasdb1;

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

       loadable.

Thanks for any help.

Super Contributor
Posts: 578

Re: Oracle database not connecting with SAS Enterprise guide 4.2

Posted in reply to nandanosho

Perhaps SASORA is for a different operating system?  Sounds like a question for Tech Support.

Regular Contributor
Posts: 180

Re: Oracle database not connecting with SAS Enterprise guide 4.2

Posted in reply to nandanosho

You have to be sure that SAS/ACCESS to ORACLE is installed, licensed and configured correctly in the SAS server before you can use the libname statement.

Contributor jf
Contributor
Posts: 22

Re: Oracle database not connecting with SAS Enterprise guide 4.2

Posted in reply to nandanosho

you may need to add the option of  "schema = ".

Ask a Question
Discussion stats
  • 3 replies
  • 264 views
  • 0 likes
  • 4 in conversation