In order to connect to MySQL database from ASP you need to install MySQL ODBC connector. You can download the MySQL driver from the URL below http://dev.mysql.com/downloads/connector/odbc/ 1. Use System DSN Open Data Sources(ODBC) and add System DNS Dim adoConn Set adoConn = Server.CreateObject(“ADODB.Connection”) adoConn.Open “DSN=TestODBC;Uid=UserID;Pwd=Password;” If adoConn.errors.count = 0 t..
