Connecting to a database with a DSN

Article No. 71
Created: 01:32 AM 04.16.04
Author: Support
Original URL: http://myonlinehostingsupport.com/question.php?qstId=71


DSN connection for MS Access

Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN= databasename_domain_com"

DSN connection for MS SQL

Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN= databasename_domain_com;UID=dbm.domain.com;PWD=password"

DSN connection for MySQL

Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN= databasename_domain_com;UID=dbm.domain.com;PWD=password"

Back to original article