Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

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

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.


Site Timeline