Connecting to Sybase SQL Any 5.0
Posted on 2003-03-21
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?