01-25-2016 04:15 PM
I need access Oracle from SAS.
1) Oracle database is in another server computer,
2) local computer has SAS, but no Oracle;
3) local computer use Windows7(64 byte).
4) Now I can access Oracle from Toad, but I need access from SAS!.
Do I need install Oracle on my local computer? Or just install ODBC driver? What's dsn mean in the code below?
Proc sql ;
connect to ODBC (dsn = 'XXXX' user = gzhang password = XXXX) ;
create table CTable as
select * from connection to ODBC
Can anyone help me, I will appreciate it.
01-25-2016 04:24 PM
No, you don't need Oracle installed locally, but you do need some method of your computer talking to Oracle.
Try following the instructions here:
01-25-2016 05:40 PM
What SAS product do you have to connect to Oracle?
SAS/ACCESS to ODBC, SAS?ACCESS to OLEDB or SAS/ACCESS to Oracle? One of these must be installed and licensed to connect to Oracle. You can check your licence by running: proc setinit noalias; run;
01-26-2016 09:14 AM
I got these:
---SAS/ACCESS Interface to PC Files
---SAS/ACCESS Interface to ODBC
---SAS/ACCESS Interface to OLE DB
So I do need install Oracle on my local computer?
01-26-2016 11:17 AM
I think these are getting to be Windows/Oracle questions not really SAS related.
Regardless, you do need an ODBC driver - see your IT team or the Oracle page to download the correct one for your system.