conn.asp

架設ROSE私服必備之物 ROSE數據庫

<%
dim conn,db
dim connstr
db="../Databases/asp99cms.mdb" '数据库文件位置
on error resume next
connstr="DBQ="+server.mappath(""&db&"")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
if err then
err.clear
else
conn.open connstr
end if
sub CloseConn()
	conn.close
	set conn=nothing
end sub
%>
<%
dim title
set rs_news=server.createobject("adodb.recordset")
sqltext4="select top 1 * from Bs_Sysdata"
rs_news.open sqltext4,conn,1,1	
title=rs_news("BsCompanyName")
EnterpriseMail=rs_news("BsWebmail")
siteurl=rs_news("Bsweb")	
sitename=rs_news("Bscompanyname")		
rs_news=nothing
rs_news.close	
%>