Sas connection to oracle

[vharika18]

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

[DavePrinsloo]

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

[vharika18]

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

[DavePrinsloo]

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

[vharika18]

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

[smantha]

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.

[vharika18]

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.