opendb.asp

网易论坛 发表新贴子

<%

set my_conn=server.CreateObject("adodb.connection")
my_conn.connectiontimeout=20
my_conn.connectionstring="provider=sqloledb.1;persist security info=true;user id=sa;password=;initial catalog=asptest;data source=TEACHER628"
my_conn.open
if my_conn.state=1 then
set rst=server.CreateObject("adodb.recordset")
rst.activeconnection=my_conn
end if
%>