数据库连接范例
点击次数：16 次 发布日期：2008-11-27 18:54:56 作者：源代码网
|
<% 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" %> 源代码网供稿. |
