Hi,
I am trying to connect to a MySQL database, using the .Net framework.
I installed the newest MyODCB (3.51) and the .Net ODBC drivers from
Microsoft.
I made a System DSN using the driver, and i get it to connect - so far
so good.
But if i try making a new connection i my code using the sample
connectionstring from MySQL, i get an Exception :(
"An OLE DB Provider was not specified in the ConnectionString. An
example would be, 'Provider=SQLOLEDB;'."
What i try is:
Return New OleDb.OleDbCommand("DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=bigshop;UID=root ;PASSWORD=;OPTION=3;")
- Should I use an other connectionstring?