title: Find connection string for connecting to MySQL Server 5.1.50 using OleDbConnection
body: <p>I am interested how can I find the connection string in order to be able to connect to MySQL Server 5.1.50 using OleDbConnection(C#).</p>
  
  <p>I used this auto generated string (after adding new data source in Visual Studio): </p>
  
  <pre><code>server=localhost;User Id=MyID;password=MyPassword;database=MyDatabase 
  </code></pre>
  
  <p>but I always get the same error message:</p>
  
  <pre><code>An OLE DB Provider was not specified in the ConnectionString.  An example would be, 'Provider=SQLOLEDB;'.
  </code></pre>
  
  <p>I have tried different providers but neither of them seems to work.</p>