I have the following information i use to connect to an oracle database,
it is succssful through sqldeveloper and vb.net,
However, it fails with SAS. The SAS Statement is also below
mat1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = mid2-scan)(PORT = 1539))
)
(CONNECT_DATA = (SERVICE_NAME=mat1))
)
username
password
SAS libname i use is
libname oralib oracle user="username" password="password" path="mat1" schema="mat1";
The error message i get is
"the oracle engine cannot be found"
"error in the libname statement"
I have been access the oracle database through "sqldeveloper", i have SAS/ACCESS installed
I don't know what to next, i have tried google but not good way through
Do i have to do anything with the port, and host
Anthony
You need to have the SQL*NET client installed on the machine where SAS executes.
Thank you LinusH,
The Database guys here tell me that by the time i am able to access the oracle database through sqldeveloper and vb.net i have SQL*NET installed already. Is there a way i can test if it is installed, i have downloaded a "intallclient-sqlplus-nt-11.2.0.30". When i run it to intall sql plus it asks me for user name and password and i dont know waht to put. the database guys tell me i dont need to install anything
Anthony
make sure that your user has authorization to run the Oracle module:
Also, make sure that the PATH env variable contains the search path to ORACLE_HOME/bin.
Since this is not a standard client set up, you could create a ticket to SAS tech support, to help you verify your installation/configuration.
We have to have the oracle client on our system to connect to our oracle database through SAS (we also have a TNS file to pass additional options for offsite database). Your syntax for the libname looks correct. I would verify your local oracle install, verify you have the right SAS/ACCESS product installed (for oracle), verify your specific stuff (userid, passwd, path, schema). If all that checks out, submit a ticket with SAS.
EJ
Please I am having a similar problem now. I could not connect to Oracle 11g xe edition database from SAS. I have all required SAS component installed - SAS\ACCESS, SAS\ODBC. i connect through sqlplus, and oracle sq developer successfully. Please what is missing?
Post a NEW question with the details of your issue, this thread is old. You can link to this question if it helps explain you issue.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.