Solved

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

Posted on 2013-01-03
1
2,381 Views
Last Modified: 2013-01-06
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?
0
Comment
Question by:zimmer9
1 Comment
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 38741092
see this link for the particular connection string based on the version

http://www.connectionstrings.com/sybase-adaptive
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now