title: Connecting classic asp to mysql on iis8
body: <p>I am getting this error when attempting to connect to mysql using classic asp...
  Microsoft OLE DB Provider for ODBC Drivers error '80004005'
  [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
  I've tried many different things and I think the problem is that I am using IIS 8. </p>
  
  <p>Here is how I am trying to connect to mysql:</p>
  
  <pre><code>    Dim oConn, oRs
      Dim qry, connectstr
      Dim db_name, db_username, db_userpassword
      Dim db_server
  
       db_server = "server"
      db_name = "database"
      db_username = "uid"
      db_userpassword = "pwd"
  
      connectstr = "Driver={MySQL ODBC 3.51 Driver};SERVER=" &amp; db_server &amp; ";DATABASE=" &amp; db_name &amp; ";UID=" &amp; db_username &amp; ";PWD=" &amp; db_userpassword
      Set oConn = Server.CreateObject("ADODB.Connection")
      oConn.Open connectstr
  
      response.write("&lt;script language=""javascript""&gt;alert('Connected!');&lt;/script&gt;")
  </code></pre>
  
  <p>I also tried with the newer odbc 5.1 driver, but had no luck connecting. Any ideas as to what I should try?</p>