conn.asp

为我们公司使用的oa系统

<%
dim conn
dim connstr
'dim db
'db="database/yiuwekdsodksldfslwifds.mdb"      '数据库文件的位置
Set conn = Server.CreateObject("ADODB.Connection")
'connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
connstr="provider=SQLOLEdb.1;Initial catalog=commpany;Persist Security Info=True; PASSWORD=sa; USER ID=SA; DATA SOURCE=(LOCAL)"
'connstr="DSN=harry;Uid=harry;Pwd=harry!@#$"
conn.Open connstr

sub CloseConn()
	conn.close
	set conn=nothing
end sub
%>