Linking tables to Sybase Database

[abe6162]

I having problems linking to a Sybase Database via Access. I keep getting "Reserved error -7778, there is no message for this error".

Does anyone know anything about this error?
Is there any way for me to link a table through, VBA code?

I was able to connect to the database using ADO connection without error. I was thinking maybe setting up the link this way?

Dim adoConn As New ADODB.Connection

adoConn.ConnectionString = "Driver={SYBASE SYSTEM 11};" & _
"Srvr=DEV_TEST;" & _
"DATABASE=fin_test;" & _
"Uid=test;Pwd=test;"

adoConn.Open

adoConn.Close

 

[PHV]

You may something useful here:

http://www.peterssoftware.com/tlk.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244