How do I connect to the MySQL server using Classic ASP?

Please use the following connection string on our Windows 2008 servers to connect to the local MySQL service:

"DRIVER={MySQL ODBC 5.1 Driver}; SERVER=127.0.0.1;DATABASE=DBNAME;UID=USERNAME;PWD=PASSWORD;OPTION=3;"

Where:

DBNAME and USERNAME and PASSWORD are what you've already specified in the control panel under MySQL databases.

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

I am receiving System.Security.SecurityException or That assembly does not allow partially trusted callers.

When running your application you may see: That assembly does not allow...

How can I redirect one URL to another on ASP .NET?

Our ASP plans have the following installed:...

Cryptography with ASP .NET

A customer received the following error when attempting to create a RSACryptoServiceProvider from...

I am getting a 404 error on the secondary pages of my MVC application. Why?

To resolve the 404 error issues on secondary pages of a ASP .NET MVC applications, you will need...

My site is showing the following error: HTTP Error 503. The service is unavailable.

The error HTTP Error 503. The service is unavailable. generally means that your application pool...