topic Do I need Oracle installed in local computer in All Things Community

Do I need Oracle installed in local computer

zgp480 — Mon, 25 Jan 2016 21:15:15 GMT

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
(
select ....

Can anyone help me, I will appreciate it.

Re: Do I need Oracle installed in local computer

Reeza — Mon, 25 Jan 2016 21:24:23 GMT

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:

https://support.sas.com/techsup/technote/ts714.pdf

Re: Do I need Oracle installed in local computer

SASKiwi — Mon, 25 Jan 2016 22:40:01 GMT

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;

Re: Do I need Oracle installed in local computer

zgp480 — Tue, 26 Jan 2016 14:14:25 GMT

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?

Thanks.

Re: Do I need Oracle installed in local computer

Reeza — Tue, 26 Jan 2016 15:39:43 GMT

No you do not need Oracle installed on your local computer.

Re: Do I need Oracle installed in local computer

zgp480 — Tue, 26 Jan 2016 16:00:09 GMT

I don't have ODBC driver. How can I configure it? I remember I need ...ora file? I cannot remember the exact file name.

Re: Do I need Oracle installed in local computer

Reeza — Tue, 26 Jan 2016 16:17:47 GMT

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.