菜鸟问题：如何在asp中访问odbc

[zjg77]

如何在ASP中访问odbc数据源，例如：系统DSN：zjg,麻烦个尾巴代码贴出来好吗？

[forestli]

<%
dim objconnection
dim objrecordset
set objconnection=Server.CreateObject("ADODB.Connection")
set objrecordset=Server.CreateObject("ADODB.recordset")
objconnection.Open"driver={SQL Server};server=服务器地址;uid=用户名;pwd=密码;database=数据库名字"
objrecordset.open"select ntitle from news order by nid ",objconnection
%>

[SonicX]

Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "zjg"

[希偌]

chr()

[希偌]

strconn="DSN=别名"
Set conn=server.createobject("ADODB.connection")
conn.open strconn

[zjg77]

谢谢，open后是不是应该加入参数？