Cannot understand this error

unicorn11 · Jun 26, 2000

This is the error that the asp turned up when i tried to add a new record set to my database please help!

Microsoft OLE DB Provider for ODBC Drivers error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /rep/entered.asp, line 55 Unicorn11 <a href=mailto:webmaster@tripmedia.com>webmaster@tripmedia.com</a> <a href= > </a> Hi there it all likeminded fellows!!!!!!

JDurbin · Jun 27, 2000

do you know if you can successfully connect to the data source even?  If not you may need to update or reinstall the odbc/ado drivers John Durbin <a href=mailto: > </a> <a href= > </a> ICQ VFP ActiveList #73897253

palbano · Jun 27, 2000

Dear Unicorn11, What is the platform, web server, database and lets see the code up to line# 55. And while your at it, what version of MDAC is installed? -pete

unicorn11 · Jun 28, 2000

Well it is nt4 with iis 4 the code is given below <%@ Language=VBScript %> <%Response.Buffer = True%>  <% If Request.Form("product_id&quot

= "" Then   Response.Write ("The contents of this page is not viewable&quot

Else %> <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> </HEAD> <BODY> <table cellpadding="2" cellspacing="0" border="0">  <tr>   <td>Product Id</td>   <td><%=Request.Form("product_id&quot

%> </td>  </tr>  <tr>   <td>Product Name</td>   <td><%=Request.Form("product_name&quot

%> </td>  </tr>  <tr>   <td>Rate</td>   <td><%=Request.Form("rate&quot

%> </td>  </tr>  <tr>   <td>Description</td>   <td><%=Request.Form("description&quot

%> </td>  </tr>  <tr>   <td>Image Path</td>   <td><%=Request.Form("img_path&quot

%> </td>  </tr>  <tr>   <td>Quantity</td>   <td><%=Request.Form("quantity&quot

%>ml </td>  </tr>  <tr>   <td>Product Type</td>   <td><%=Request.Form("product_type&quot

%> </td>  </tr>  </table>   <%  dim rs, sql, id, vari  'Set rs = server.CreateObject ("ADODB.Recordset&quot

id = Request.Form("product_id&quot

vari =  Cstr(id)  sql = "Insert into product_mst (product_id, product_name, rate, description, img_path, quantity, product_type)"  sql = sql + " values ('"& vari & "','" & Request.Form("product_name&quot

& "'," & Request.Form("rate&quot

& ",'" & Request.Form("description&quot

& "','" & Request.Form("img_path&quot

& "'," & Request.Form("quantity&quot

& "," & Request.Form("product_type&quot

& &quot

;"  'sql = "select * from product_mst"  Response.Write sql  set rs = con.Execute(sql)  'Response.Write (  ' rs.Open sql, con,1, 3  '  rs.AddNew ' rs("product_id&quot

= vari ' rs("product_name&quot

= Request.Form("product_name&quot

' rs("rate&quot

= Request.Form("rate&quot

' rs("description&quot

= Request.Form("description&quot

' rs("img_path&quot

= Request.Form("img_path&quot

' rs("quantity&quot

= Request.Form("quantity&quot

' rs("product_type&quot

= Request.Form("product_type&quot

' rs.Update  Response.Write ("The new product with the above details was added to the Database&quot

'rs.close 'Set rs = Nothing %> <ul>  <li><a href="dataentry.asp?type=2&cat=<%=Request.Form("cata&quot

%>">Click here to add another product to the same catagory</a>  <li><a href="dataentry.asp?type=1">Click here to add a product to a new catagory</a> </ul> </BODY> </HTML> <%   End If %> i have used both rs.addnew method and the insert statement in sql both ways it does not help! Unicorn11 <a href=mailto:webmaster@tripmedia.com>webmaster@tripmedia.com</a> <a href= > </a> Hi there it all likeminded fellows!!!!!!

palbano · Jun 29, 2000

Dear Unicorn11, These two items first: 1) >Response.Write sql You should be able to copy the output SQL statement into your database environment (Access, SQL Server, whatever) and successfully execute it. 2) >set rs = con.Execute(sql) The SQL statement you are executing does not return a result set. I have never executed equivalent code so I am not sure what type of error it might or might not produce. Let me know how it's going -pete

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Cannot understand this error

unicorn11

Programmer

JDurbin

Programmer

palbano

Programmer

unicorn11

Programmer

palbano

Programmer

Similar threads

Part and Inventory Search

Sponsor