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

核心提示：OLE DB Method for SQL<%set cnn = server.createobject("ADODB.Connection")cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD

　　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"
　　%>