topic Error while connecting Oracle database from SAS in SAS Programming https://communities.sas.com/t5/SAS-Programming/Error-while-connecting-Oracle-database-from-SAS/m-p/183887#M303441 <HTML><HEAD></HEAD><BODY><P><BR /><SPAN style="font-family: arial,helvetica,sans-serif;">Hi,</SPAN></P><P></P><P>I am trying to connect Orracle database from SAS server(SAS Management console).</P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">Previously we had odbc connectivity to connect to oracle database from SAS.Now We have bought SAS/Access license to oracle .</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">We have installed the oracle driver in SAS.</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">I created a new server in SAS Management console and a created a library for that.</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">I have listed the Service name (available in tnsnames.ora) while creating a library in the path column.</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">While registering the table , I am getting the following error </SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;"><STRONG>ORA-12154:TNS:could not resolve the connect identifier specified</STRONG></SPAN></P><P></P><P><SPAN style="font-size: 10pt; font-family: arial,helvetica,sans-serif;">I can able to view SASORA and SASIOORA file in my installation folder.</SPAN></P><P></P><P><SPAN style="font-size: 10pt; font-family: arial,helvetica,sans-serif;">Kindly help us if any new client needs to be installed in SAS server.</SPAN></P></BODY></HTML> Mon, 24 Feb 2014 13:18:06 GMT Helannivas 2014-02-24T13:18:06Z Error while connecting Oracle database from SAS https://communities.sas.com/t5/SAS-Programming/Error-while-connecting-Oracle-database-from-SAS/m-p/183887#M303441 <HTML><HEAD></HEAD><BODY><P><BR /><SPAN style="font-family: arial,helvetica,sans-serif;">Hi,</SPAN></P><P></P><P>I am trying to connect Orracle database from SAS server(SAS Management console).</P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">Previously we had odbc connectivity to connect to oracle database from SAS.Now We have bought SAS/Access license to oracle .</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">We have installed the oracle driver in SAS.</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">I created a new server in SAS Management console and a created a library for that.</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">I have listed the Service name (available in tnsnames.ora) while creating a library in the path column.</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">While registering the table , I am getting the following error </SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;"><STRONG>ORA-12154:TNS:could not resolve the connect identifier specified</STRONG></SPAN></P><P></P><P><SPAN style="font-size: 10pt; font-family: arial,helvetica,sans-serif;">I can able to view SASORA and SASIOORA file in my installation folder.</SPAN></P><P></P><P><SPAN style="font-size: 10pt; font-family: arial,helvetica,sans-serif;">Kindly help us if any new client needs to be installed in SAS server.</SPAN></P></BODY></HTML> Mon, 24 Feb 2014 13:18:06 GMT https://communities.sas.com/t5/SAS-Programming/Error-while-connecting-Oracle-database-from-SAS/m-p/183887#M303441 Helannivas 2014-02-24T13:18:06Z Re: Error while connecting Oracle database from SAS https://communities.sas.com/t5/SAS-Programming/Error-while-connecting-Oracle-database-from-SAS/m-p/183888#M303442 <HTML><HEAD></HEAD><BODY><P>I believe SAS Access for Oracle still requires the oracle runtime libraries to be installed on the base sas server.</P></BODY></HTML> Mon, 24 Feb 2014 17:25:07 GMT https://communities.sas.com/t5/SAS-Programming/Error-while-connecting-Oracle-database-from-SAS/m-p/183888#M303442 DBailey 2014-02-24T17:25:07Z