TomPhillips
asked on
Connecting to Sybase SQL Any 5.0
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?
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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