sql数据库连接语句，sql数据库连接方法,sql数据库如何连接

connstr="PROVIDER=SQLOLEDB; DATA SOURCE=bds-019.hichina.com; UID=bds0190084; PWD=u3r9a6t1w2; DATABASE=bds0190084_db"

'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