How to query a MySQL database in ASP

To query a MySQL database using Classic ASP you will need to use one of the MySQL ODBC drivers installed on our system:
  • MySQL ODBC 5.3 Unicode Driver
  • MySQL ODBC 5.3 ANSI Driver
Example connection string using Classic ASP to call a MySQL database:
Dim cnnSimple  ' ADO connection 	
Dim rstSimple  ' ADO recordset 	
Set cnnSimple = Server.CreateObject("ADODB.Connection") 	
' DSN 	
cnnSimple.Open "DRIVER={MySQL ODBC 5.3 Unicode Driver};SERVER=[mySQL server];
Set rstSimple = cnnSimple.Execute("SELECT * FROM tblTest")
<P> Connecting to mySQL DB</P> 	
<table border="1"> 	
Do While Not rstSimple.EOF 	
  <td><%= rstSimple.Fields("id").Value %></td> 	
  <td><%= rstSimple.Fields("name").Value %></td> 	
' Close our recordset and connection and dispose of the objects rstSimple.Close Set rstSimple = Nothing cnnSimple.Close Set cnnSimple = Nothing