connection issue to oracle database

[molla]

Hi ,

I have installed SAS University edition in my lap ,I also have oracle database,I am trying to get the data from oracle database by connecting to it through passthrough facility in sas,am getting the following error,am new in doing this,pls help me out,

proc sql;

63 connect to oracle (user=hr password=XX path='D:\Users\rmolla\Desktop\New folder (4)');

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.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

64 create table test1 as

65 select * from connection to oracle

66 (select * from departments);

Regards,

Rubia.

[Kurt_Bremser · Accepted solution]

SAS UE does not support connections to databases.

Export tables from the DB to flat files and import those via the shared folder into SAS UE.