conn.asp

来自「苏州人才市场」· ASP 代码 · 共 44 行

<%
dim connstr,connm,SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName
db="../../%100lastvictor/with a clear conscience.asp"
'-----------------------------------------------------------------------------------------------------
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/#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
%>