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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.