急!在asp中调用数据库插入语句总是有错误,后台是oracle
程序源代码如下:
其中MM_cnNewBookShow_STRING="dsn=booklib;uid=system;pwd=manager;"
并且在asp中运行select语句一切正常可以正确显示数据库中的数据,但是不能执行与insert有关的插入
语句,比如下面三种情况都提示错误:
1.在command对象中执行存储过程;
2.在command对象中执行insert into ......
3.如下源代码所示在recordset中执行update语句
提示的错误为:Microsoft OLE DB Provider for ODBC Drivers (0x80004005) /lib/1.asp, 第18行
<%@LANGUAGE="javaSCRIPT"%>
<!--#include file="Connections/cnNewBookShow.asp" -->
<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_cnNewBookShow_STRING;
Recordset1.Source = "SELECT * FROM SCOTT.READER";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 3;
Recordset1.Open();
Recordset1.AddNew();
Recordset1("cardno")=Request.Form("cardno");
Recordset1("regname")=Request.Form("regname");
Recordset1("password")=Request.Form("password");
Recordset1("question")=Request.Form("question");
Recordset1("answer")=Request.Form("answer");
Recordset1("recommnum")=0;
Recordset1.Update();//错误行所在
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
</body>
</html>
<%
Recordset1.Close();
%>