谁能帮忙解读以下ASP代码(急用)!!!

来源:百度知道 编辑:UC知道 时间:2024/05/17 00:03:13
<%
'Set conn = Server.CreateObject("ADODB.Connection")
'conn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=9DEDCADB12244F7\EDGEWIND;UID=sa;PWD=xb123456xb;DATABASE=#QG_DB#"

set conn=server.createobject("ADODB.CONNECTION")
'db="Database/sanweidb.mdb" '数据库文件位置
on error resume next
'connstr="PROVIDER=SQLOLEDB;DATA SOURCE=9DEDCADB12244F7\EDGEWIND;UID=sa;PWD=xb123456xb;DATABASE=#QG_DB#"
conn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=218.85.134.6;UID=sq8qiguanggroup;PWD=sq8qiguanggroup;DATABASE=sq8qiguanggroup"
'connstr="DBQ="+server.mappath(""&db&"")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"

if err then
err.clear
else
conn.open connstr
end if

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

请尽量详细些,每一句什么意思。急用!!!谢谢!!

<%
'Set conn = Server.CreateObject("ADODB.Connection")
'conn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=9DEDCADB12244F7\EDGEWIND;UID=sa;PWD=xb123456xb;DATABASE=#QG_DB#"

这以上是链接数据库的语句 用的是sql server数据库 9DEDCADB12244F7\EDGEWIND是计算机名 UID=sa是数据库用户名是sa PWD=xb123456xb是数据库密码是xb123456xb DATABASE=#QG_DB#是说数据库名字为=#QG_DB#
set conn=server.createobject("ADODB.CONNECTION")
'db="Database/sanweidb.mdb" '数据库文件位置
on error resume next

这几行是用的access数据库链接语句

'connstr="PROVIDER=SQLOLEDB;DATA SOURCE=9DEDCADB12244F7\EDGEWIND;UID=sa;PWD=xb123456xb;DATABASE=#QG_DB#"
conn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=218.85.134.6;UID=sq8qiguanggroup;PWD=sq8qiguanggroup;DATABASE=sq8qiguanggroup"

这几行跟上面一样 是sql server数据库链接语句
'connstr="DBQ="+server.mappath(""&db&"")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};&quo