2.8w+
社区成员
- 主页
请教个简单的数据库连接
我建立了个系统DSN，测试连接成功。在asp中怎样来用？就是刚开始的数据库初始连接。
dim conn string
string=dsn="xxx",......
....
set conn=server.greaterobject("adodb.connection")
conn.open string
我不会写这段代码，请大家给个完整的代码！
dim conn string
string=dsn="xxx",......
....
set conn=server.greaterobject("adodb.connection")
conn.open string
我不会写这段代码，请大家给个完整的代码！
...全文
请发表友善的回复…
发表回复
zyqherozyqhero 2002-07-31
set cn=server.createobject("adodb.connection")
cn.open "dsn=testdb;uid=sa;pwd="
set rs=server.createobject("adodb.recordset")
rs.open "select * from "&fbry1&"xsdw",cn,3
cn.open "dsn=testdb;uid=sa;pwd="
set rs=server.createobject("adodb.recordset")
rs.open "select * from "&fbry1&"xsdw",cn,3
MeXP 2002-07-31
set conn=server.createrobject("adodb.connection")
conn.open "DSNname"
conn.open "DSNname"
freelyl 2002-07-31
懒得打和复制了，用VB的DATA控件连接一下照抄。
celeron831 2002-07-31
SET DBCONNECTION=SERVER.CREATEOBJECT("ADODB.CONNECTION")
strCnn = "Driver={Microsoft Access Driver (*.mdb)};" &_
"DBQ= "& Server.MapPath("/database/数据库名.mdb")
DBCONNECTION.connectionstring=strcnn
DBCONNECTION.open
其实你可这样：SET DBCONNECTION=SERVER.CREATEOBJECT("ADODB.CONNECTION")
DBCONNECTION.open "DSN名称"
strCnn = "Driver={Microsoft Access Driver (*.mdb)};" &_
"DBQ= "& Server.MapPath("/database/数据库名.mdb")
DBCONNECTION.connectionstring=strcnn
DBCONNECTION.open
其实你可这样：SET DBCONNECTION=SERVER.CREATEOBJECT("ADODB.CONNECTION")
DBCONNECTION.open "DSN名称"
peter_zy 2002-07-31
strconn = "Driver={SQL Server};Description=sqldemo;SERVER=服务器名;UID=sa;PWD=;DATABASE=数据库名"
set conn = server.createobject("adodb.connection")
conn.open strconn
set conn = server.createobject("adodb.connection")
conn.open strconn