title: ASP.NET use SqlConnection connect MySQL
body: <p>This is the connection string saved in <code>web.config</code>:</p>
  
  <pre><code>&lt;appSettings&gt;
      &lt;add key="conn" value="Driver={MySQL ODBC 5.1 Driver};server=127.0.0.1;uid=root;pwd=1234;database=gis_server;option=3"/&gt;
      &lt;/appSettings&gt;
  </code></pre>
  
  <p>This is the code to connect to the database:</p>
  
  <pre><code>protected bool CheckPasswordBySqlServer(string strEmail, string strPsw)
  {
      if (strEmail.ToLower() == "admin")
      {
          return false;
      }
      string str = "select id,Rank,RankEnc,ParentUser,Company from tbl_User where userName=@UserName and password1=@password";
      private string strConn = ConfigurationManager.AppSettings["conn"].ToString();
      SqlConnection sqlConnection = new SqlConnection(strConn);
      bool flag = false;
      try
      {
          try
          {
              sqlConnection.Open();
              SqlCommand sqlCommand = new SqlCommand(str, sqlConnection);
              sqlCommand.Parameters.AddWithValue("UserName", strEmail);
              sqlCommand.Parameters.AddWithValue("Password", strPsw);
              SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
              if (!sqlDataReader.Read())
              {
                  flag = false;
              }
              else
              {
                  this.Session["UserName"] = strEmail;
                  this.Session["Password"] = strPsw;
                  this.Session["LoginType"] = "Group";
                  this.Session["FullName"] = sqlDataReader["Company"].ToString();
                  if (FormsAuthentication.HashPasswordForStoringInConfigFile(string.Concat(strEmail, (char)43, sqlDataReader["Rank"].ToString()).ToLower(), "MD5") != sqlDataReader["RankEnc"].ToString().Trim())
                  {
                      flag = false;
                  }
                  this.Session["ClientID"] = sqlDataReader["id"].ToString();
                  this.Session["MyLanguage"] = base.Request.Cookies["Language"].Value;
                  this.Session["ParentUser"] = sqlDataReader["ParentUser"].ToString().Trim();
                  this.Session["Rank"] = sqlDataReader["Rank"].ToString();
                  this.Session["strConnection"] = this.strConn;
                  flag = true;
              }
              sqlDataReader.Close();
          }
          catch (Exception exception)
          {
              this.SetlblInfoHtml(exception.Message);
          }
      }
      finally
      {
          sqlConnection.Close();
      }
      return flag;
  }
  </code></pre>
  
  <p>But it fails to connect MySQL, with this return error:</p>
  
  <pre><code>System.ArgumentException: Keyword not supported: 'driver'. at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions&amp; userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at Source_LoginFrm.CheckPasswordBySqlServer(String strEmail, String strPsw) at Source_LoginFrm.btnLogin_Click(String strLang)
  </code></pre>
  
  <p>Is that possible SqlConnection to connect MySQL database?</p>