一個典型的SQL Server數據庫連接范例

　　OLE DB Method for SQL
　　<%
　　set cnn = servercreateobject(ADODBConnection)
　　cnnopen PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=databasename
　　%>
　　
　　DSN Less connection for Access
　　<%
　　set cnn = servercreateobject(ADODBConnection)
　　cnnopen DRIVER={Microsoft Access Driver (*mdb)};DBQ=c:\anydatabasemdb
　　%>
　　
　　OLE DB Method for Access
　　<%
　　set cnn = servercreateobject(ADODBConnection)
　　cnnopen PROVIDER=MICROSOFTJETOLEDB;DATA SOURCE=c:\anydatabasemdb
　　%>
　　
　　File DSN Connection Method for Access
　　<% set cnn = servercreateobject(ADODBConnection)
　　cnnopen FILEDSN=AccessDSN
　　%>
From:http://tw.wingwit.com/Article/program/SQLServer/201311/22033.html