Issue with connection string in web config file

Question

I am trying to set the mysql connection in web config file.

Here is the connection string code:

    <connectionStrings>
    <add name="connstring" 
         connectionString="DRIVER={MySQL ODBC= 3.51=        Driver};Database=marctest;Server=localhost;UID=root;PWD=1234;" 
         providerName="System.Data.SqlClient"/>
    </connectionStrings>

and i am accessing it in following step:

    MySqlConnection connmysql = new MySqlConnection(WebConfigurationManager.ConnectionStrings["connstring"].ConnectionString);

When I run my code it generates a null reference exception."Object reference not set to an instance of an object."

How can I resolve this issue?

Answer 1

If you are using the MySql .Net Connector then your configuration setting should look similar to the following

<add name="connstring" connectionString="server=localhost;User Id=root;Persist Security Info=True;database=marctest;password=PASSWORD" providerName="MySql.Data.MySqlClient"/>

Then your code should look like.

using (MySqlConnection dbConn = new MySqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ConnectionString)) 
{ 
    // Database work done here 
}

Answer 2

I think you have MySql Connector/Net API. Change the ProviderName attribute and have a look at ConnectionStrings. It should be MySql.Data.MySqlClient and use System.Configuration.ConfigurationManager.ConnectionStrings collection.