请教个简单的数据库连接

[bzwht2002]

我建立了个系统DSN，测试连接成功。在asp中怎样来用？就是刚开始的数据库初始连接。
dim conn string
string=dsn="xxx",......
....


set conn=server.greaterobject("adodb.connection")
conn.open string

我不会写这段代码，请大家给个完整的代码！

[peter_zy]

strconn = "Driver={SQL Server};Description=sqldemo;SERVER=服务器名;UID=sa;PWD=;DATABASE=数据库名"
set conn = server.createobject("adodb.connection")
conn.open strconn

[celeron831]

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名称"

[freelyl]

懒得打和复制了，用VB的DATA控件连接一下照抄。

[MeXP]

set conn=server.createrobject("adodb.connection")
conn.open "DSNname"

[zyqherozyqhero]

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