数据库连接范例

OLE DB Method for SQL

1   
2set cnn = server.createobject("ADODB.Connection")   
3cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=databasename "

DSN Less connection for Access

1   
2set cnn = server.createobject("ADODB.Connection")   
3cnn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\anydatabase.mdb"

OLE DB Method for Access

1   
2set cnn = server.createobject("ADODB.Connection")   
3cnn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=c:\anydatabase.mdb"

File DSN Connection Method for Access

1 set cnn = server.createobject("ADODB.Connection")   
2cnn.open "FILEDSN=AccessDSN"