I am developing an Access application using an MDB type file.
I call a Sybase stored procedure.
I originally had the following code when I used an ODBC connection with
Sybase driver "DataDirect 4.0 Sybase Wire Protocol".
oConn.Open "DSN=NYP_D_M;" & _
'"Uid=PWMC;" & _
'"Pwd=Tl"
Now I am changing the Sybase driver to Adaptive Server Enterprise.
I changed the code to the following:
Set oConn = CreateObject("ADODB.Connection")
oConn.Open "Driver={Adaptive Server
Enterprise};database=apex_digimail;server=v248;port=8;AuthenticationClient=kerberos;ServerPrincipal=sybase/v248"
I get the error:
Run-time error '-2147467259 (80004005)':
[Micorsoft] [ODBC Driver Manager] Data source name not found and no default driver specified.
Do you know how I can resolve this error?