MySql Connection String

Question

Can someone tell me whats wrong with my connection string below thats in the app config. The error I am getting An Ole DB provider was not specifiied in the connection string. I tried both ways adding the Ole DB provided and i still get am error. Review below.

<add name="ConnectionString" connectionString="server=xxxx11111;User Id=root;password=mypassword;database=colorDatabase" providerName="MySql.Data.MySqlClient"/>

using (OleDbConnection conn = new OleDbConnection(ConnectionString))
using (OleDbConnection conn = new OleDbConnection(ConnectionString))
{
conn.Open(); //Error Occurs

using (OleDbCommand cm = conn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "GetColorSerialPartNumber";
cm.ExecuteReader();

while (cm.ExecuteReader().Read())
{
Console.WriteLine(cm.ToString());
}

}
}

David Smith · Answer

Nevermind I see the mistake. Thanks for your help.

David Smith · Answer

I am getting an error now saying connection must be valid and open, but when i un comment the open() i get connection already open, im not for sure why. using (MySqlConnection conn = new MySqlConnection(ConnectionString)) { //conn.Open(); using (MySqlCommand cm = conn.CreateCommand()) { cm.CommandType = CommandType.StoredProcedure; cm.CommandText = "prc_GetColorSerialPartNumber"; cm.ExecuteReader(); while (cm.ExecuteReader().Read()) { Console.WriteLine(cm.ToString()); } } }

David Smith · Answer

I am so slow, that was my mistake using the wrong provider, not paying attention I am using OleDb instead of MySql.Data.MySqlClient, I am looking right at it in the app.config. I need to be hit by a bus, let me test anyway.

Satyapriya Nayak · Answer

Hi Darnell, Please refer the below link http://markalexanderbain.suite101.com/how-to-access-mysql-with-c-a115001 Thanks