MySql Connection String

David Smith

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.

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());
}

}
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

David Smith14y ago
Nevermind I see the mistake. Thanks for your help.
David Smith14y ago
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 Smith14y ago
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 Nayak14y ago
Hi Darnell,

Please refer the below link

http://markalexanderbain.suite101.com/how-to-access-mysql-with-c-a115001

Thanks