22 proc sql;
23 connect to oracle(user=shruthi password=XXXX path='SAS');
ERROR: The ORACLE engine cannot be found.
ERROR: A Connection to the oracle DBMS is not currently supported, or is not installed at your site.
24 select * from connection to oracle(select * from plans_2008 unionall select * from plans_2009);
ERROR: The ORACLE engine cannot be found.
ERROR: A Connection to the oracle DBMS is not currently supported, or is not installed at your site.
25 disconnect from oracle;
ERROR: Connection to the oracle DBMS does not exist.
26 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.08 seconds
cpu time 0.01 seconds
Why is my application unable to connect to oracle?
It appears you don't have SAS/ACCESS to Oracle installed in your environment. Run proc product_status; run; to verify.
You might be able to connect using ODBC (if you have SAS/ACCESS to ODBC).
It appears you don't have SAS/ACCESS to Oracle installed in your environment. Run proc product_status; run; to verify.
You might be able to connect using ODBC (if you have SAS/ACCESS to ODBC).
The connection method you attempted would have required the output to show something like
For SAS/ACCESS to Oracle
The result means that was not loaded.
You can run Proc Setinit; run; to show what is licensed. It may be that you have a license but the module wasn't installed for you. Which could be an easy partial reinstall. If Oracle (or the ODBC) doesn't appear in the license then license changes will be needed and then an updated install.
Without ODBC or the Oracle you will be stuck until one is installed.
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.