ASP数据库连接方式程序-星想互联

ASP数据库连接方式程序

点击数：2781 发布时间2013-04-07 17:32:09

set conn= Server.CreateObject("adodb.connection")

'connstr="driver={microsoft access driver (*.mdb)};dbq="& Server.mappath("datasourcename/news.mdb")&";"
'conn.open connstr

db="mydata/News##_1.mdb"
db=Server.MapPath(db)
Set conn = Server.CreateObject("ADODB.Connection")

connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &db

conn.Open "Driver={SQL Server};Server=.\SQLEXPRESS;Database=dbcompanyMember;Uid=sa;Pwd=990911"

来源：星想互联