MySQL and VS.NET

MySQL and VS.NET

am 17.02.2006 05:14:32 von zMisc

Can I use the MyODBC with VS.NET?

I've used MyODBC with Visual basic 6 and have not problems.

Now I am trying to use it in VB.NET and get this error when I used the same
connection string from VB6.

"Connection String: Driver={MySQL ODBC 3.51 Driver}; Server=localhost;
Database=Sys; UID=test; PWD=Pwd; OPTION=3

An OLE DB Provider was not specified in the ConnectionString. An example
would be, 'Provider=SQLOLEDB;'."

The connection string I specified is:

Driver={MySQL ODBC 3.51
Driver};Server=localhost;Database=test;UID=test;PWD=pwd;OPTI ON=3

Can I use the standard data adaptor class instead of the MySQL Connector
which I have also installed. Since, my app also works with the Access
database, I hope that I can use the
standard dataadapter class instead of the MySQL version.

Tks
John