用dreamewaver做网页将数据插入数据库报错:ADODB.Connection 错误 '800a0e7a'
未找到提供程序。该程序可能未正确安装。
代码如下:
<%
tmpyouraccount=request.form("youraccount")
tmpyourname=request.form("yourname")
tmppwd=request.form("pwd")
tmpsex=request.form("sex")
tmpclass=request.form("class")
tmphobby=request.form("hobby")
tmpclass=request.form("class")
'set cn=server.createobject("adodb.connection")
'cn.open "driver={sql server};server=jcb;database=text4;uid=sa;pwd=123"
set cn=server.createobject("adodb.connection")
strconn="driver={microsoft access driver (*.mdb)};dbq="&server.mappath("text4.mdb")
cn.open strconn
set rs=server.createobject("adodb.recordset")
selstr="select * from useinfo where youraccount='" & tmpyouraccount & "'"
rs.open selstr,cn
if not (rs.eof) then
response.write "<script language=JavaScript>" & "alert('该账号已被占用,请重新选择账号!');" & "history.back();" & "</script>"
rs.close
set rs=nothing
cn.close
set cn=nothing
else
'set cn=server.createobject("adodb.connection")
'cn.open "driver={sql server};server=jcb;database=text4;uid=sa;pwd=123"
set cn=server.createobject("adodb.connection")
strconn="driver={microsoft access driver (*.mdb)};dbq="&server.mappath("text4.mdb")
cn.open strconn
strin= "insert into useinfo(youraccount,yourname,sex,class,hobby,pwd)"
strin=strin&"values('"&tmpyouraccount&"','"&tmpyourname&"','"&tmpsex&"','"&tmpclass&"','"&tmphobby&"','"&tmppwd&"')"
cn.execute strin
response.write "<script language=JavaScript>" & "alert('注册成功!');" & "history.back();" & "</script>"
end if
%>
求大神支招,”启用 32 位应用程序”,已经设置为 True了。可是还没有解决。