DSN-less Connection String syntax!

Type One - This is the one I use the most w/Access! DSN-Less Connection example #1

strconn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("aspfree.mdb")
set conn = server.createobject("adodb.connection")
conn.open strconn

Type Two - This is the one I use the most w/MS-Sql 7! DSN-Less Connection example #2

strconn = "Driver={SQL Server};Description=sqldemo;SERVER=127.0.0.1;UID=LoginID;PWD=Password; DATABASE=Database_Name
set conn = server.createobject("adodb.connection")
conn.open strconn

Type Three - DSN-Less Connection example #2

strconn="Driver={MicrosoftAccessDriver(*.mdb)};DBQ=F:\Inetpub\wwwroot\somedir\db1.mdb;DefaultDir=

f:\Inetpub\wwwroot\somedir;uid=LoginID;pwd=Password;DriverId=25;FIL=MSAccess;" set conn = server.createobject("adodb.connection")
conn.open strconn

Type Four - using a System Data Source Name

The following uses a Data Source Name:

set conn = server.createobject("adodb.connection")
conn.open "Example"
'This is created in the Control Panel using the 32 bit ODBC Driver. If you don't know how to setup here is a perfect example on ActiveServerPages.com

Type Five - Not using a connection and just using a ODBC DSN. Note:You have to setup an odbc Entry in the Control Panel

set rs = server.createobject("adodb.recordset")
rs.open "tblname", "DSNName", 3, 3

Dsn-less code from our Microsoft Friends!

http://www.microsoft.com/data/ado/adords15/docs/adoprox1_7.htm