HomeASP HostingWeb DesignRegister DomainSupportAbout Us

Support :: FAQ

How to connect to MySQL database from ASP
MySQL is a perfect database solution for small to medium websites. If your backend MySQL database is well optimized and properly structured it can serve thousands of visitors daily, without degrading your server performance. In this article I'll show you how to connect to MySQL database from ASP. You will have to install MySQL ODBC Driver-MyODBC 3.51 if you don't have it on your server yet. You can download it here: http://www.mysql.com/downloads/api-myodbc-3.51.html

Dim sConnection, objConn , objRS

sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=Your_Mysql_DB; UID=mysql_username;PASSWORD=mysql_password; OPTION=3"

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


Set objRS = objConn.Execute("SELECT FirstName, LastName FROM tblUsers")

While Not objRS.EOF
  Response.Write objRS.Fields("LastName") & ", " & objRS.Fields("FirstName") & "<br>"
  Response.Write & " "

Set objRS = Nothing
Set objConn = Nothing
Copyright 2001-2004 Art Branch Inc.