problem connecting to mysql from vs2010

Question

Hello, I am trying to connect to mysql using c# in vs2010. I installed the 6.3.5 version of the .net connector from the mysql site. I try using the following connection string -

<add name="mySql" connectionString="Server=localhost;Database=mydb;Uid=User;Pwd=mypass;" providerName="System.Data.OleDb.OleDbConnection, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

and am getting the following error -

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

So I then change the connection string to -

<add name="mySqlTarget" connectionString="Provider=MySQLProv;Server=localhost;Database=mydb;Uid=User;Pwd=mypass;" providerName="System.Data.OleDb.OleDbConnection, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

And get the following error -

The 'MySQLProv' provider is not registered on the local machine.

Does anyone have any idea why this is happening?

thanks for any thoughts.

Answer 1

Take a look at http://www.connectionstrings.com/mysql. However, you should not go through the OLEDB provider. Try something like:

<add name="mySql"
     connectionString="Server=localhost;Database=mydb;Uid=User;Pwd=mypass;" 
     providerName="MySql.Data.MySqlClient"/>