www.webdeveloper.com
Results 1 to 2 of 2

Thread: Operation is not allowed when the object is closed.

  1. #1
    Join Date
    May 2012
    Posts
    1

    Operation is not allowed when the object is closed.

    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

  2. #2
    Join Date
    Mar 2006
    Location
    Discworld
    Posts
    75
    From error it look like you did not actually open recordset.
    Possibility is something wrong with your DB definition.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles