connection issue to oracle database

molla — Thu, 22 Jun 2017 10:19:41 GMT

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.

Re: connection issue to oracle database

Kurt_Bremser — Thu, 22 Jun 2017 10:21:33 GMT

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.

topic Re: connection issue to oracle database in SAS Programming

connection issue to oracle database

Re: connection issue to oracle database