How to resolve error [Micorsoft] [ODBC Driver Manager] Data source name not found and no default driver specified when calling a Sybase stored procedure?

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?
zimmer9Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
see this link for the particular connection string based on the version

http://www.connectionstrings.com/sybase-adaptive
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.