Oracle connection error

[shruthinayakvad]

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? 

[ChrisHemedinger · Accepted solution]

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).

[shruthinayakvad]

31 proc product_status;
32 run;

For Base SAS Software ...
Custom version information: 9.4_M2
Image version information: 9.04.01M2P072314
For SAS/STAT ...
Custom version information: 13.2
For SAS/GRAPH ...
Custom version information: 9.4_M2
For SAS/ETS ...
Custom version information: 13.2
For SAS/OR ...
Custom version information: 13.2
For SAS/IML ...
Custom version information: 13.2
For High Performance Suite ...
Custom version information: 2.2_M1
For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.4_M2
NOTE: PROCEDURE PRODUCT_STATUS used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds

I did run the statement mentioned.The above appears in log.
??

[ballardw]

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.