Connecting to Sybase with ADO

[Timtropolis]

Greetings all,

I am using Access 2003 to connect via ADO to a Sybase db on our server. My problem
lies in the connection string. Since I can connect via ODBC I figured I'd just copy the
string that pops up for the tables (holding the mouse cursor over a table reveals the
connections string. Here is what the code looks like :

Dim cnn As New ADODB.Connection

cnn.Open "ODBC;DSN=NYT_NAVTEST;NLN=Winsock;NA=hqidb41,7809;" & _ 
"DATABASE=navigator;UID=seshkanu;PWD=seshkanu"

However, when I try to run this, I get a runtime error stating:

"Microsoft ODBC Driver Manager - DSN not found and no default driver specified."

I then typed in the driver name and got the same message (I'm using Data Direct 4.2 Sybase driver)

I then came on here and found another example and tried it:

    cnn.Open "Provider=DataDirect ODBC 4.2;Data Source=NYT_NAVIGATOR;;" & _
        "User ID=seshkanu;Password=seshkanu"

This time it told me the driver does not exist as it is looking for a file extension that ends with "IDS". Guess this is the datasource name?? not sure.

anyway, I'm kind of fustrated here, so I was wondering is someone can guide me as to another way of handling this. I have a feeling that I'm missing something simple here. BTW, my over all goal is to do some recordset processing which involves alot of logic, hence the need for this code.

Any help would be greatly appreciated!!
TIA

Tim