problem connecting to mysql from vs2010

Question

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.

Pieter van Ginkel · Accepted Answer · 2010-10-29 18:38:33Z

3

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"/>

answered Oct 29, 2010 at 18:38

Pieter van Ginkel

29.7k8 gold badges77 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

czuroski Over a year ago

yeah - that is what I ended up with. I got my connections mixed up and was trying to use the oledb when I should have been using the mysql connector. thanks

Travis Spencer Over a year ago

The MySQL .NET Connector is said to be an OLE DB provider, so it should work to use that. This approach seems better because then you don't have to recompile your .NET code when you want to use some other OLE DB compliant DB.

Collectives™ on Stack Overflow

problem connecting to mysql from vs2010

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related