title: delphi mysql ado connectivity
body: <p>I'm trying to get an ADO connection working in Delphi XE3 and am having major difficulty.</p>
  
  <p>I have an ODBC driver installed on my machine (Win7 x64) the driver shows as 'mySQL ODBC 5.1 driver' under ODBC data sources.  Mysql version 5.5.</p>
  
  <p>My understanding is that I should be able to put a TadoConnection component on the form and then assign an appropriate connection string to it as below:</p>
  
  <pre><code>var
    conn: TADOConnection;
  
  procedure TForm1.Button1Click(Sender: TObject);
  begin
    conn := conn.Create(nil);
    conn.ConnectionString := 'DRIVER={MySQL ODBC 5.1 Driver}; SERVER=myserver; PORT=3306; DATABASE=mysql; UID=myuser; PASSWORD=mypassword;OPTION=3;';
    conn.Connected := true;
  end;
  </code></pre>
  
  <p>When I run the application and click the button, I get an error </p>
  
  <blockquote>
    <p>Project Project1.exe raised exception class EOleException with message '[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'.</p>
  </blockquote>
  
  <p>Can anyone help me? What have I missed?  I've tried looking for examples on the web and have had no joy so far..  Any advice is greatly received...</p>