conn.asp

来自「在线考试系统」· ASP 代码 · 共 18 行

<%
	on error resume next
	dim url,uid,pwd,dbname'数据库服务器地址，用户名，密码，数据库名称	
	url="localhost"
	uid="sa"
	pwd="sa"
	dbname="testdata"
	'constr="DRIVER={sql server};Server="+url+";database="+dbname+";uid="+uid+";pwd="+pwd
	constr="Provider=SQLOLEDB.1;Password="&pwd&";Persist Security Info=True;User ID="&uid&";Initial Catalog="&dbname&";Data Source="&url

	set conn=server.createobject("adodb.connection")
	conn.open  constr
	'response.write(conn.state)
	if(err)then
	response.write("<br><font color='red'>连接数据库出错！<BR>如有问题请联系管理员！</font>")
	end if
%>