title: Which connection string for MySql ODBC connector 5.2.6?
body: <p>it seems i can't make work a connection to MySql using ODBC connector 5.2.6.
  In a 64 bit environment, in a VBA excel application, i use this string, but it not work:</p>
  
  <blockquote>
    <p>"Driver={MySQL ODBC 5.2
    Driver}; Server=myserver;Database=mydb;User=readonly;Password=mypass;Option=3"</p>
  </blockquote>
  
  <p>I have also used</p>
  
  <pre><code>Driver={MySQL ODBC 5.2w Driver}
  </code></pre>
  
  <p>and</p>
  
  <pre><code>Driver={MySQL ODBC 5.2a Driver}
  </code></pre>
  
  <p>But the error is: ODBC driver unknow.</p>
  
  <p>Can someone help me ? </p>
  
  <p>Ps: it works with a DSN setted, but i would like to use a connection string so i don't go to each user computer and set a DSN.</p>
  
  <p>Thanks</p>