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