<div>
<div class="content wysiwyg-content">
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 &quot;DataDirect 4.0 Sybase Wire Protocol&quot;. 
 
oConn.Open &quot;DSN=NYP_D_M;&quot; &amp;&nbsp;_ 
&nbsp; &nbsp;'&quot;Uid=PWMC;&quot; &amp;&nbsp;_ 
&nbsp; &nbsp;'&quot;Pwd=Tl&quot; 
 
 
Now I am changing the Sybase driver to Adaptive Server Enterprise. 
I changed the code to the following: 
 
 
Set oConn = CreateObject(&quot;ADODB.Connection&quot;) 
&nbsp; &nbsp; 
oConn.Open &quot;Driver={Adaptive Server 
 
Enterprise};database=apex_digimail;server=v248;port=8;AuthenticationClient=kerberos;ServerPrincipal=sybase/v248&quot; 
&nbsp; &nbsp; 
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?
</div>
</div>

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?

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

Microsoft Windows XP is the sixth release of the NT series of operating systems, and was the first to be marketed in a variety of editions: XP Home and XP Professional, designed for business and power users. The advanced features in XP Professional are generally disabled in Home Edition, but are there and can be activated. There were two 64-bit editions, an embedded edition and a tablet edition.

Windows XP

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Sybase Database

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.