连接数据库的问题哟,
dim Conn
dim Connstr
set conn = server.createobject("adodb.connection")
'-----------------SQL SERVER 7.0数据库连接------------
'connstr="Driver={SQL Server};Server=(local);UID=cwecn;PWD=cwecn2002;Database=ndata"connstr="Provider=SQLOLEDB.1;User ID=cwecn;Initial Catalog=ndata;Data Source=(local);password=cwecn2002"'connstr="DBQ=" & server.mappath("data/nbook.mdb") & ";driver={Microsoft Access Driver (*.mdb)};"conn.open connstr
dim Conn
dim Connstr
set conn = server.createobject("adodb.connection")
'-----------------SQL SERVER 7.0数据库连接------------
'connstr="Driver={SQL Server};Server=(local);UID=cwecn;PWD=cwecn2002;Database=ndata"connstr="Provider=SQLOLEDB.1;User ID=cwecn;Initial Catalog=ndata;Data Source=(local);password=cwecn2002"'connstr="DBQ=" & server.mappath("data/nbook.mdb") & ";driver={Microsoft Access Driver (*.mdb)};"conn.open connstr
dbmssocn.dll
dbnetlib.dll
dbnmpntw.dll
ntwdblib.DLL
pbdwe60.dll
pbmss60.dll
pbvm60.dll
SQLCA.Database = "SMIS"
SQLCA.LogPass = "0"
SQLCA.ServerName = "202.197.232.131"
SQLCA.LogId = "yangxipeng"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""
connect;