Operation is not allowed when the object is closed.

[nishavarghese]

Hi All,

I am using classic ASP when i am using store procedure for retrive value from data base .when i execute my procedure i don't get any value in my record set .Even i checked on sp in backend i get one rows

my code is as follows:

set rscontainer1 = server.CreateObject("ADODB.Recordset")
sqlcontainer1= "USP_ASP_IMP_CONSOLE_GENERATE_SEA_IU '"&containerno&"' , '"&trim(expt_vessel)&"','"&trim(sentfrom)&"','"&trim(icmpcode)&"','"&trim(icitycode)&"','"&trim(icit ycode1)&"','"&icmp_loginid&"','"&trim(userid)&"' "


rscontainer1.cursortype = adopenstatic
rscontainer1.open sqlcontainer1,db

if not rscontainer1.eof then
Response.Write(rscontainer1.recordcount & "<BR>")
end if

i got error in my if condition

error is :

ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.



Pls Help

Thanks
Nisha

[alexsts]

From error it look like you did not actually open recordset.
Possibility is something wrong with your DB definition.