Connecting to ASP pages with or without DSN

How does MySQL compare to Access 2000 and SQL Server as a back end for ASP pages? Does it run as a file like Access does, or as a service like SQL Server?

    Requires Free Membership to View

    Login

You can connect ASP pages to MySQL using ODBC. Download the ODBC drivers. Once you have MyODBC configured, you can connect to MySQL with or without DSN. 

Using DSN:
<%
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DSN=mysql_dsn"
%>

Without DSN:
<%
set conn = createobject("ADODB.Connection") conn.open = "DRIVER={MySQL ODBC 3.51 Driver};" & _
 "SERVER=yourHostName;" & _
 "DATABASE=yourDBName;" & _
 "UID=yourUserName;PWD=yourPassword; OPTION=35;"
%>
Check for values for the OPTION parameter.

This was first published in September 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top