How do I connect to MySQL with ASP?

19/12/2017 2:59 PM
- Databases
- MySQL

This applies to Windows Hosting accounts only. You will need to use a DSNless connection which can be achieved by using code with the following VBscript:

set rsEvents = Server.CreateObject("ADODB.Recordset") rsEvents.ActiveConnection = "Driver={MySQL ODBC 5.1 Driver}; DATABASE=databasename;USER=username; PASSWORD=password; Server=127.0.0.1"

...or the following JScript:

var rsEvents = Server.CreateObject("ADODB.Recordset"); rsEvents.ActiveConnection = "Driver={MySQL ODBC 5.1 Driver}; DATABASE=databasename;USER=username; PASSWORD=password; Server=127.0.0.1";

Share via

Did you find this article useful?

How do I connect to MySQL with ASP?

Related Articles

Categories