AcroNOC Inc. Company Blog

Connection code for DSN less MySQL connection with ASP pages.

Connection code for DSN less MySQL connection with ASP pages

Create a database connection in the .ASP code as follows:

< %
    Set Conn = Server.CreateObject("ADODB.Connection")
    Conn.Open "Driver={MySql}; Server=localhost; uid=myLogin; pwd=myPass; database=myDB; option=3; port=3306;"
    Set rsmyTable = Conn.Execute("SELECT * From myTable")
% >

Substitute myDomain.com, myDB, myLogin, myPass, myTable with your own specific details.