topic Re: Sas connection to oracle in SAS Programming

Sas connection to oracle

vharika18 — Wed, 03 Jun 2020 17:45:38 GMT

How to connect sas 9.4 version running on windows 10 to Oracle 10g .

Re: Sas connection to oracle

DavePrinsloo — Wed, 03 Jun 2020 19:36:07 GMT

Your organisation needs to have licenced SAS/ACCESS product. The SAS administrators at your site should be able to provide you the connection details.

Re: Sas connection to oracle

smantha — Wed, 03 Jun 2020 19:56:04 GMT

To add on to dave prinsloo's response. you need to have a SAS/Access for Oracle or SAS/Access to ODBC. For SAS/Access to ODBC you need to setup other than the module itself you need to setup configuration on your system.

Re: Sas connection to oracle

vharika18 — Thu, 04 Jun 2020 09:30:11 GMT

I am using licensed version ##- Please type your reply above this line. No
attachments. -##

Re: Sas connection to oracle

DavePrinsloo — Thu, 04 Jun 2020 09:48:25 GMT

Sorry but your reply does not help. Run following code

proc setinit; run;

Check that there is a line on the log like SAS/ACCESS Interface to Oracle

or AS/ACCESS Interface to ODBC.

If that is not the case, then your site has not licenced the appropriate SAS product.

If it is the case, then you need to contact the SAS administrator / Oracle administrator to provide you with connection information

Re: Sas connection to oracle

vharika18 — Tue, 09 Jun 2020 12:12:12 GMT

Hi I am not getting sas access to oracle so I tried to connect to odbc. I
installed odbc drivers also but of no use. Can u plz suggest me regarding
this.

Re: Sas connection to oracle

vharika18 — Wed, 10 Jun 2020 09:50:11 GMT

I have sas access to oracle I worked through odbc also but failed to
connect .one more doubt I have is whether windows 10 supports all these