Problem solve Get help with specific problems with your technologies, process and projects.

Connecting to ASP pages with or without DSN

MySQL expert Scott Noyes explains how to connect MySQL 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?

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.

Dig Deeper on Linux servers

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.