一个典型的SQLServer数据库连接范例

　　OLE DB Method for SQL　　<%　　set cnn = server.createobject("ADODB.Connection")　　cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=databasename "　　%>　　　　DSN Less connection for Access　　<%　　set cnn = server.createobject("ADODB.Connection")　　cnn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:anydatabase.mdb"　　%>　　　　OLE DB Method for Access　　<%　　set cnn = server.createobject("ADODB.Connection")　　cnn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=c:anydatabase.mdb"　　%>　　　　File DSN Connection Method for Access　　<% set cnn = server.createobject("ADODB.Connection")　　cnn.open "FILEDSN=AccessDSN"　　%>