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