MySQL and VS.NET
am 17.02.2006 05:14:32 von zMiscCan 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