课后小结范例 一个典型的SQL Server数据库连接范例

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

　　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 ;DATA SOURCE=c:anydatabase mdb 　　%>　　　　File DSN Connection Method for Access　　<% set cnn = server createobject( ADODB Connection )　　cnn open FILEDSN=AccessDSN 　　%> lishixinzhi/Article/program/SQLServer/201311/22033