title: MySQL 5.6.14 64 Bit Connection Issue on Windows 8.1 Pro 64 Bit
body: <p>I am trying to connect my classic ASP website to the MySQL database. I am using the following:</p>
  
  <pre><code>1. OS: Windows 8.1 Pro 64 bit
  2. DB: MySQL 5.6.14 64 bit
  3. ODBC Driver: MySQL ODBC 5.2 ANSI Driver
  4. IIS: IIS 8
  </code></pre>
  
  <p>Here is what I have done till now.</p>
  
  <p>I have downloaded the MySQL 5.6.14 64 bit database from MySQL website and installed it successfully. The database is working perfectly as I am able to create tables, stored procedures etc.</p>
  
  <p>Next I created a folder (mira_dev) inside the wwwroot folder and wrote 3 classic asp pages. The first one is the login.asp page, the second one is the checklogin.asp page and the last one being the index.asp page.</p>
  
  <p>Now I am able to see "It works!" in my browser. </p>
  
  <p>I next created a System DSN in the ODBC Data Source Administrator (64-bit). I named it as MySQL 64 Bit, TCP/IP Server as 127.0.0.1, Port as 3306, then username as root and password as root. I tested the connection and it says "Connection successful".</p>
  
  <p>The connection string that I am using is:</p>
  
  <pre><code>strconnect = ("Driver={MySQL ODBC 5.2 ANSI Driver};Server=localhost; Port:4040;Database=mira_dev;User=root;Password=root;Option=4;")
  </code></pre>
  
  <p>I next typed in the path to my login page on my browser and the login page came up alright.</p>
  
  <p>I typed in the username and password as expected and hit Enter. The expected result is, after I hit enter it should authenticate me via the invisible page checklogin and then if it matches with the database, it should pass me to index.asp.</p>
  
  <p>Now here is the catch. If I do this in Chrome/Firefox, it takes me to index.asp but instead of showing the correct contents it displays the error message: "An error occurred on the server when processing the URL. Please contact the system administrator.
  If you are the system administrator please click here to find out more about this error." The "click here" takes me to a page which tells me how to configure classic asp with mysql. I have done all that and I think I am on the correct path but missing something very silly. </p>
  
  <p>But if I do the same steps in IE 11, then it stops me at checklogin.asp and tells me there is a server error. I am sure the logic in checklogin for authentication is fine as it works in my other computer but I am not sure what I am missing.</p>
  
  <p>It would be of great help if you guys help me out. Thanks a lot in advance! :)</p>