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"