Knowledgebase

Connect to a mysql database using a dsn connection via asp

If you have defined the DSN on the Web Server, then the connection string is simply:

Dim conn

set conn=Server.CreateObject(ADODB.Connection)
conn.ConnectionString = "DSN=<your DSN>"

conn.open

>>where you replace <Your DSN> with the name of the DSN that you created to point to the database.<<

Note:To use the above connection string you make sure that you have to create a DSN for the database.

Tip *:To create DSN for the MySql database,please refer "how we can setup a system DSN to access our MySQL database through ASP" article in this section.*

Add to Favourites

Print this Article

Portal Home
Client Area
Announcements
Knowledgebase
Submit Ticket
Downloads
Order