06-18-2013 04:16 AM
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
(PROTOCOL = TCP)(HOST = mid2-scan)(PORT = 1539))
(CONNECT_DATA = (SERVICE_NAME=mat1))
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
06-18-2013 04:33 AM
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-220.127.116.11". 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
06-18-2013 07:19 AM
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.
06-18-2013 10:19 AM
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.