BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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.

The error message is "Connection Failed. Error Code: -101188867 ct_connect(): directory service layer: internal directory control layer error: Requested server name not found".

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.

Has anybody else seen anything like this before?

Thanks so much in advance,

Donna Tunstall
4 REPLIES 4
Ksharp
Super User
It looks like you are unsuccessed to config your client Sybase .
Or you can try to use ODBC.


Ksharp
deleted_user
Not applicable
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.
Ksharp
Super User
Hi.
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).
Or Google it may will be helpful.


Ksharp
deleted_user
Not applicable
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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 3808 views
  • 0 likes
  • 2 in conversation