mySQL ASP ADO Connection Syntax

We now have ChiliSoft ASP installed on all of our shared servers.

See http://www.chilisoft.com/caspdoc/ for the ChiliSoft on-line documentation.

See http://www.mysql.net/ for more information about mySQL.

ASP mySQL ADO DSNLess connection Syntax:

<%
Set cn = Server.CreateObject ("ADODB.Connection")

strConn = "DRIVER={mySQL};HOST=<IP>;SERVER=<IP>;DATABASE=<USER ID>;UID=<USER ID>;PWD=<PASSWORD>"

Set rs = Server.CreateObject ("ADODB.RecordSet")

cn.Open strConn
%>

Substitute your information for the following:

<IP> - Put in your domain IP address
<USER ID> - Put in your user id
<PASSWORD> - Put in your password
 

Do you have any questions not answered by our on-line help? Contact Tech Support via our Support Request Form

to Dynamic Net, Inc.