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
  • 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

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

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

In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses
Course of the Month12 days, 17 hours left to enroll

578 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