conn.asp

来自「一个ASP写的在线考试系统」· ASP 代码 · 共 32 行

<%
dim conn   
dim connstr   
'on error resume next
call conn_init()
sub conn_init()
	'on error resume next
	connstr = "DBQ=" + server.mappath("../data.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"       
	set conn=server.createobject("ADODB.CONNECTION")
	if err.number<>0 then 
		err.clear
		set conn=nothing
		response.write "数据库连接出错！"
		Response.End
	else
		'response.write connstr
		conn.open connstr
		if err then 
			err.clear
			set conn=nothing
			response.write "数据库连接出错！"
			Response.End 
		end if
	end if   
end sub

sub endConnection()
	conn.close
	set conn=nothing
end sub

%>