asp 代码查错 关于ACCESS交互的

来源:百度知道 编辑:UC知道 时间:2024/05/16 06:15:49
如题:
POST m_strTel=strTel&m_Ip=Ip&m_SysInfo=SysInfo&m_Time=Time
时显示:
HTTP/1.1 500 Internal Server Error
Date: Sun, 16 Dec 2007 05:11:09 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Content-Length: 43
Content-Type: text/html
Set-Cookie: ASPSESSIONIDQACBQQTA=HEKHFEFCCLPLAIPMCNFHGFIF; path=/
Cache-control: private

处理 URL 时服务器出错。请与系统管理员联系。

请问哪里出错了.

该代码如下:
<%
strTel =request.form("m_strTel")
Ip =request.form("m_Ip")
SysInfo =request.form("m_SysInfo")
Time =request.form("m_Time")

'-----------------------------------------------------------------
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("flashbookuser/user.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
'-------------------------------------------------------

CONN的参数改成1,3看怎么样?
我改的如下:
'---------------------
<%
strTel =request.form("m_strTel")
Ip =request.form("m_Ip")
SysInfo =request.form("m_SysInfo")
Time =request.form("m_Time")

'-----------------------------------------------------------------
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("flashbookuser/user.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
'-----------------------------------------------------------------
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from vio"
rs.open sql,conn,1,3
rs.addnew
rs("strTel")=strTel
rs("Ip")=Ip
rs("SysInfo")=SysInfo
rs("Time")=Time
rs.update
rs.close
response.end
%>