主题:老是报"服务器内部错误",晕死了!
各位大哥,我是才学ASP的,我写的这个插入操作怎么老是报"服务器内部错误"啊?
是程序的问题?还是我数据库连接的问题?我的数据库是Server SQL 2000
<%
Dim RS,strbuilding,strfloor,strdepartment,strplace,strperson,strport,strIP,strteam,strexplain,strSQL
Set RS = Server.CreateObject("ADODB.Recordset")
strbuilding=request.form("building")
strfloor=request.form("floor")
strdepartment=request.form("department")
strplace=request.form("place")
strperson=request.form("person")
strport=request.form("port")
strIP=request.form("IP")
strteam=request.form("team")
strexplain=request.form("explain")
strSQL="select * from IPdetail"
RS.Open strSQL ,MM_conn_STRING,1,3
RS.addnew
RS("building")=strbuilding
RS("floor")=strfloor
RS("department")=strdepartment
RS("place")=strplace
RS("person")=strperson
RS("port")=strport
RS("IP")=strIP
RS("team")=strteam
RS("explain")=strexplain
RS.update
RS.Close
'MM_conn_STRING.close
Set RS = Nothing
'Set MM_conn_STRING = Nothing
'Response.Write"变量为:"&strbuilding&strfloor&strdepartment &strplace &strperson &strport &strIP &strteam &strexplain
%>
请各位大虾帮忙看一下!
是程序的问题?还是我数据库连接的问题?我的数据库是Server SQL 2000
<%
Dim RS,strbuilding,strfloor,strdepartment,strplace,strperson,strport,strIP,strteam,strexplain,strSQL
Set RS = Server.CreateObject("ADODB.Recordset")
strbuilding=request.form("building")
strfloor=request.form("floor")
strdepartment=request.form("department")
strplace=request.form("place")
strperson=request.form("person")
strport=request.form("port")
strIP=request.form("IP")
strteam=request.form("team")
strexplain=request.form("explain")
strSQL="select * from IPdetail"
RS.Open strSQL ,MM_conn_STRING,1,3
RS.addnew
RS("building")=strbuilding
RS("floor")=strfloor
RS("department")=strdepartment
RS("place")=strplace
RS("person")=strperson
RS("port")=strport
RS("IP")=strIP
RS("team")=strteam
RS("explain")=strexplain
RS.update
RS.Close
'MM_conn_STRING.close
Set RS = Nothing
'Set MM_conn_STRING = Nothing
'Response.Write"变量为:"&strbuilding&strfloor&strdepartment &strplace &strperson &strport &strIP &strteam &strexplain
%>
请各位大虾帮忙看一下!