Connect to MySQL database from ASP

I'll show you how to connect to MySQL database from ASP script. Once we have connected to the MySQL database from ASP, you'll learn how to select data from a MySQL database table and display the results in a browser.

In order to connect to MySQL database from ASP you need to install MySQL ODBC Driver-MyODBC 3.51. You can download the MySQL driver from the URL below:


Dim sConnection

Dim oConnection

Dim oRS

sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=; UID=;PASSWORD=< Put your MySQL password here >; OPTION=3"

Set oConnection = Server.CreateObject("ADODB.Connection")


Set oRS = oConnection.Execute("SELECT * FROM Table1")

While Not oRS.EOF

Response.Write oRS ("Column1") & " " & oRS ("Column2") & "





Set oRS = Nothing


Set oConnection = Nothing


MySQL database is a great database server, which can be used as a website backend. You can install MySQL on your local development machine and test your ASP MySQL connections from there. Many Windows web hosting providers offer MySQL hosting as a standard feature, and many Windows web developers use MySQL as website database engine.