How do I connect to MySQL with ASP?

To connect to a MySQL database through ASP on your Windows hosting account:

You will need to use a DNSless connection, which you can achieve with the following VBScript:

set rsEvents = Server.CreateObject("ADODB.Recordset")

rsEvents.ActiveConnection = "Driver={MySQL ODBC 5.1 Driver}; DATABASE=[DATABASE NAME];USER=[USER NAME]; PASSWORD=[PASSWORD]; Server=[SERVER IP ADDRESS]"

Or the following JScript:

var rsEvents = Server.CreateObject("ADODB.Recordset");

rsEvents.ActiveConnection = "Driver={MySQL ODBC 5.1 Driver}; DATABASE=[DATABASE NAME];USER=[USER NAME]; PASSWORD=[PASSWORD]; Server=[SERVER IP ADDRESS]";

Replace [DATABASE NAME] with the name of your database.

Replace [USER NAME] with your user name.

Replace [PASSWORD] with your password.

Replace [SERVER IP ADDRESS] with your server’s IP address or name (which you can find in your eXtend control panel).

Article ID: 13
Created On: Thu, Feb 26, 2015 at 5:08 PM
Last Updated On: Thu, Apr 23, 2015 at 10:41 AM

Online URL: https://www.heartinternet.uk/support/article/how-do-i-connect-to-mysql-with-asp.html