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")
oConnection.Open(sConnection)
Set oRS = oConnection.Execute("SELECT * FROM Table1")
While Not oRS.EOF
Response.Write oRS ("Column1") & " " & oRS ("Column2") & "
"
oRS.MoveNext
Wend
oRS.Close
Set oRS = Nothing
oConnection.Close
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.