Knowledgebase

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}; 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}; DATABASE=databasename;USER=username; PASSWORD=password; Server=127.0.0.1";

Add to Favourites

Print this Article