Connecting to Sybase SQL Any 5.0

Posted on 2003-03-21
Medium Priority
Last Modified: 2010-05-18
I'm new to VB.NET.  I have to access a database called "ep3" that we get to via ODBC and Sybase SQL Any 5.0. from VB6. With Server Explorer, I can see the DB and it's structure, can list the tables.  If I drag the OledbDataAdapter to my form, the Data Adapter Config Wiz. starts.  I go to the PROVIDERS tab and select MS OLE DB Provider for ODBC Drivers and hit NEXT. I then enter the datasource name "ep3" and usrid and password, then hit TEST CONNECTION. It succedes!  When I hit OK, I get "The connection you have created does not work with the current adapter."  I get the same error if I use the SQLData Adapter. What am I doing wrong?

Question by:TomPhillips
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2

Expert Comment

ID: 8189723
You need to select a different provider, which for Sybase 5.x is MSDASQL, and not MS OLE DB provider.  I hope this helps. I have successfully worked with a Sybase 5.x connection, i was forced to create a DSN, and then call the DSN with this connection string:
Provider=MSDASQL; DSN=mySybaseDSN

Author Comment

ID: 8195425
Shaka913, I need just a little more Information.  When you say forced to create a DSN, do you mean a FILE DSN? Which driver do you start with, There is no MSDASQL choice in the list of providers I have.  

Accepted Solution

Shaka913 earned 750 total points
ID: 8196114
I created a system DSN via the ODBC control panel applets. I picked "Sybase SQL anywhere 5.0" from the list

Hope this helps

Author Comment

ID: 8197257
OK, I didn't realize that I needed to add the ADODB reference. I found that out by going to an old VB6 program and upgrading it with the wizzard. Thanks for your help.

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

800 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