https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-Sybase-Error/m-p/17635#M3172 Hi There: I am hoping someone can help. We have recently been given new PCs at work, however on practically all of them the connection from SAS to Sybase fails. <BR /> <BR /> The error message is "Connection Failed. Error Code: -101188867 ct_connect(): directory service layer: internal directory control layer error: Requested server name not found".<BR /> <BR /> Only on one machine have we been able to successfully connect, we have done the exact same process on the remaining machines and have not had any success.<BR /> <BR /> Has anybody else seen anything like this before?<BR /> <BR /> Thanks so much in advance,<BR /> <BR /> Donna Tunstall Fri, 25 Feb 2011 13:42:53 GMT deleted_user 2011-02-25T13:42:53Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-Sybase-Error/m-p/17635#M3172 Hi There: I am hoping someone can help. We have recently been given new PCs at work, however on practically all of them the connection from SAS to Sybase fails. <BR /> <BR /> The error message is "Connection Failed. Error Code: -101188867 ct_connect(): directory service layer: internal directory control layer error: Requested server name not found".<BR /> <BR /> Only on one machine have we been able to successfully connect, we have done the exact same process on the remaining machines and have not had any success.<BR /> <BR /> Has anybody else seen anything like this before?<BR /> <BR /> Thanks so much in advance,<BR /> <BR /> Donna Tunstall Fri, 25 Feb 2011 13:42:53 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-Sybase-Error/m-p/17635#M3172 deleted_user 2011-02-25T13:42:53Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-Sybase-Error/m-p/17636#M3173 It looks like you are unsuccessed to config your client Sybase .<BR /> Or you can try to use ODBC.<BR /> <BR /> <BR /> Ksharp Mon, 28 Feb 2011 07:09:36 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-Sybase-Error/m-p/17636#M3173 Ksharp 2011-02-28T07:09:36Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-Sybase-Error/m-p/17637#M3174 Hi. Thanks so much for the reply. That's the odd thing though, we can connect to Sybase using Microsoft Access via ODBC. It is only through SAS that we are seeing this error. Mon, 28 Feb 2011 14:27:20 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-Sybase-Error/m-p/17637#M3174 deleted_user 2011-02-28T14:27:20Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-Sybase-Error/m-p/17638#M3175 Hi.<BR /> Are you using Sybase IQ or Sybase A...... ,if it is latter, it seems that needing to add something into xxxx.ini file (Sorry, I have forgotten).<BR /> Or Google it may will be helpful.<BR /> <BR /> <BR /> Ksharp Tue, 01 Mar 2011 02:07:42 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-Sybase-Error/m-p/17638#M3175 Ksharp 2011-03-01T02:07:42Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-Sybase-Error/m-p/17639#M3176 That did it! We have Sybase ASE and it's the SQL.ini file that wasn't pointing to the right server. Thank you so much for the help. Tue, 01 Mar 2011 16:34:51 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-Sybase-Error/m-p/17639#M3176 deleted_user 2011-03-01T16:34:51Z