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!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recordset Error

Status
Not open for further replies.
sap

sap

Technical User
Aug 20, 2001
37
IN
Hello,
i'm learning asp.While inserting data into access database,
i used follwing code(asp file) it actually inserts the data
but gives Error. Please help.

Error Type :
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
/myasp/MailListInsert.asp, line 13

********
The code for
MailListInsert.asp

<%@ language=VBScript %>
<html>
<head><title>This is ASP Page</title></head>
<body>
<%
info=&quot; ' &quot;&Request.Form(&quot;t1&quot;)&&quot; ',' &quot;&Request.Form (&quot;t2&quot;)&&quot; ',' &quot;&Request.Form (&quot;t3&quot;)&&quot; ',' &quot;&Request.Form (&quot;t4&quot;)&&quot; ' ,' &quot;&Request.Form (&quot;t5&quot;)&&quot; '&quot;
%>
<%
set con= Server.Createobject(&quot;adodb.Connection&quot;)
con.Open &quot;dsn=acc&quot;
set rs= con.Execute(&quot;insert into MailingList(FirstName,LastName,City,Country,Email) values(&quot;&info&&quot;)&quot;)
%>
<%
rs.close
con.close

%>
 
Sort by date Sort by votes
The problem is that you are attempting assign a recordset to a variable (rs) that hasn't been declared as a recordset object variable. You must first declare &quot;rs&quot; just like you did &quot;con&quot;.
Code: 
set con= Server.Createobject(&quot;adodb.Connection&quot;)
set rs = Server.Createobject(&quot;adodb.Recordset&quot;)
This should do the trick
 
Upvote 0 Downvote
Have you tried using Response.Write to pinpoint the error?
Also use set rs= nothing
and set con = nothing
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Krus1972
  • Locked
  • Question
msxml3.dll error '80072f7d' - An error occurred in the secure Channel support
Replies
7
Views
1K
Krus1972
Krus1972
leifoet
  • Locked
  • Question
Using date picker gives an error message, only at application start
Replies
1
Views
596
MarkSweetland
MarkSweetland
chikwendu
  • Locked
  • Question
OraOLEDB error '80040e4b'
Replies
1
Views
869
xwb
xwb
evr72
  • Locked
  • Question
formatting error
Replies
3
Views
334
evr72
evr72
BunBo900
  • Locked
  • Question
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Replies
1
Views
478
BunBo900
BunBo900

Part and Inventory Search

Sponsor

Back
Top