title: VBA connect to MySQL DB
body: <p>I try to connect my Excel Spreadsheet to my MySQL DB hosted locally for the moment. I'm using WAMPSERVER.</p>
  
  <p>Here is my VBA code : </p>
  
  <pre><code>Dim oConn As ADODB.Connection
  Private Sub ConnectDB()
      Set oConn = New ADODB.Connection
      oConn.Open "DRIVER={MySQL ODBC 5.1 Driver};" &amp; _
          "SERVER=localhost;" &amp; _
          "DATABASE=test;" &amp; _
          "USER=root;" &amp; _
          "PASSWORD=;" &amp; _
          "Option=3"
  End Sub
  </code></pre>
  
  <p>I created my db "test" on through phpMyadmin... I have an error when I run the code.
  Do you have an idea?</p>