asp与数据库连接mssql

随便写写了.

很简单的.与access

da_path="**.mdb"
set rs=server.CreateObject("adodb.recordset")
set conn=server.CreateObject("adodb.connection")
conn.connectionstring="provider=microsoft.jet.oledb.4.0; data source="&server.mappath("**.mdb")
conn.open
end sub

与mssql

sub opensql()
set sqlrs=server.CreateObject("adodb.recordset")
set sqlcn=server.createobject("adodb.connection")
sqlconstr="driver={sql server};server=xiewen;uid=sa;pwd=123456;database=gerobak"
sqlcn.open sqlconstr
end sub