title: An OLE DB Provider was not specified in the ConnectionString. 'Provider=SQLOLEDB;
body: <p>i trying to run query using C#, i am getting the following problem</p>
  
  <blockquote>
    <p>An OLE DB Provider was not specified in the ConnectionString.  An example would be, 'Provider=SQLOLEDB;</p>
  </blockquote>
  
  <p>my code</p>
  
  <pre><code>string strConString = System.Configuration.ConfigurationManager.ConnectionStrings["WorkflowConnStr"].ConnectionString.ToString(); 
  string sqlstr = "select * from table"        
  OleDbConnection myConnection = new OleDbConnection(strConString);
  try
       {myConnection.Open();}
  catch (Exception err) 
       { System.Diagnostics.Debug.WriteLine(err.Message); }
  
  OleDbCommand myCommand = new OleDbCommand(sqlstr, myConnection);
  OleDbDataReader reader = myCommand.ExecuteReader();
  </code></pre>
  
  <p>web.config</p>
  
  <pre><code>&lt;add name="WorkflowConnStr" connectionString="Data Source=Server;Initial Catalog=DBName;user id=usr;password=password" providerName="System.Data.OleDb.OleDbConnection"/&gt;
  </code></pre>
  
  <p>any suggestion ?</p>