UC知道我的conn.asp连接不上数据库
来源：百度知道 编辑：UC知道 时间：2024/06/19 20:10:54
conn.asp里的代码
<%
dim dbpath,conn,startime,db,rs,rs1,rs2,rs3,rs4,rs5,rs6,rs7,rs8,fw_chushou,fw_city,fw_quyu,fw_dizhi,fw_jiaotong,fw_leixing,fw_jiegou,fw_louceng,fw_mianji,fw_zhuangxiu,fw_jiage,fw_lxdh,fw_OICQ,fw_lxname,fw_fbri,fw_guoqi,fw_qtsm,fw_peitao,pud,pwd,pwd2,uname,xb,sfz,email,tel,tishi,tsda
db="data/xuqi.mdb"'这里修改数据库路径或名称
Set conn = Server.CreateObject("ADODB.Connection")
dbpath="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
'SqlLocalName ="127.0.0.1" '连接IP [ 本地用 (local) 外地用IP ]
SqlUsername ="User" '用户名
SqlPassword ="Pass" '用户密码
SqlDatabaseName="Name" '数据库名
dbpath="Provider=Sqloledb;User ID=" & SqlUsername & "; Password=" & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source=" & SqlLocalName & ";"
<%
dim dbpath,conn,startime,db,rs,rs1,rs2,rs3,rs4,rs5,rs6,rs7,rs8,fw_chushou,fw_city,fw_quyu,fw_dizhi,fw_jiaotong,fw_leixing,fw_jiegou,fw_louceng,fw_mianji,fw_zhuangxiu,fw_jiage,fw_lxdh,fw_OICQ,fw_lxname,fw_fbri,fw_guoqi,fw_qtsm,fw_peitao,pud,pwd,pwd2,uname,xb,sfz,email,tel,tishi,tsda
db="data/xuqi.mdb"'这里修改数据库路径或名称
Set conn = Server.CreateObject("ADODB.Connection")
dbpath="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
'SqlLocalName ="127.0.0.1" '连接IP [ 本地用 (local) 外地用IP ]
SqlUsername ="User" '用户名
SqlPassword ="Pass" '用户密码
SqlDatabaseName="Name" '数据库名
dbpath="Provider=Sqloledb;User ID=" & SqlUsername & "; Password=" & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source=" & SqlLocalName & ";"
dbpath="Driver={SQL Server};server=(local);uid=user;pwd=pass;database=Name"
conn.open dbpath
连接语句好象没什么错误.我想应该是你的SQL数据库用户名和密码的问题.
把uid=user;pwd=pass 改成uid=sa;pwd=sa试试看.
把错误代码帖出来，这个怎么看的出错对