Problems Connecting To Sybase

[XL428]

I am using VB6 to connect to Sybase and I can't seem to connect. I'm using the following code:

Dim Dim cnCCard As ADODB.Connection

On Error GoTo ERR_Connect

Set cnCCard = New Connection

cnCCard.ConnectionString = "Driver={Sybase System 11};SRVR=10.120.21.200;" & _
"DB=facetsconvert;UID=xxx;PWD=xxx"

cnCCard.Open

I'm getting the following error: "[INTERSOLVE][ODBC SQL Server Driver][SQL Server]ct_connect(): directory service layer: internal directory control layer error: Requested Server Name Not Found"

What am I doing wrong? I have only worked with Microsoft SQL Server up until now and haven't had much Sybase experience. I am forgetting something? PLEASE HELP!!!

 

[MatsHulten]

Try adding a Data Enviroment to your project, then adding the connection that way, using a guide (Much easier, if you are having problems). Then when you have got the connection to work, you have the connection string in the connection string property of the connection object in the DE. Just copy that, and you are set to go!

Good Luck!
-Mats Hulten