conn.asp

无错的招聘网站,可以直接使用,谢谢大家支持

<%
dim connstr,connm,SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName
db="../../database/#_ZT_rc^data.mdb"
'-----------------------------------------------------------------------------------------------------
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connstr
If Err Then
	err.Clear
	Set Conn = Nothing
	Response.Write "主数据库连接出错，请检查连接字串。"
	Response.End
End If

Sub CloseConn()

	Conn.close
	set Conn=nothing
End sub


dim connstrItem
dim dbItem
dim connItem
dbItem="database/d#Item.mdb"       
'On Error Resume Next
Set connItem = Server.CreateObject("ADODB.Connection")
connstrItem="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(dbItem)
connItem.Open connstrItem
If Err Then
   err.Clear
   Set ConnItem = Nothing
   Response.Write "采集数据库连接出错，请检查连接字串。"
   Response.End
End If

Sub CloseConnItem()
   On Error Resume Next
   ConnItem.close
   Set ConnItem=nothing
End sub
%>