call storedprocdeure from asp

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • vinodkus@gmail.com
    #1

    call storedprocdeure from asp

    dear sir/madam

    I have created a stored procedure using if and else if. this stored
    procedure only select
    record from table. and I have done paginh\g in asp page.
    so It gives error
    like

    ADODB.Recordset error '800a0cb3'

    Current Recordset does not support bookmarks. This may be a limitation
    of the provider or of the selected cursortype.

    /Tiecon/request_meet.as p, line 613

    error line no is

    rs.AbsolutePage = currentpage

    I think calling of this stored proceudure is somethig different method
    I m calling like this

    rs.CursorType=a dOpenStatic
    rs.open sql,conn
    pagecount = rs.pagecount

    please tell me what is the problem

    Thanks in advance
    Tags: None
    • Bob Barrows [MVP]
      #2
      Re: call storedprocdeure from asp

      Change the cursortype to adUseClient

      vinodkus@gmail. com wrote:
      dear sir/madam
      >
      I have created a stored procedure using if and else if. this stored
      procedure only select
      record from table. and I have done paginh\g in asp page.
      so It gives error
      like
      >
      ADODB.Recordset error '800a0cb3'
      >
      Current Recordset does not support bookmarks. This may be a limitation
      of the provider or of the selected cursortype.
      >
      /Tiecon/request_meet.as p, line 613
      >
      error line no is
      >
      rs.AbsolutePage = currentpage
      >
      I think calling of this stored proceudure is somethig different method
      I m calling like this
      >
      rs.CursorType=a dOpenStatic
      rs.open sql,conn
      pagecount = rs.pagecount
      >
      please tell me what is the problem
      >
      Thanks in advance
      --
      Microsoft MVP -- ASP/ASP.NET
      Please reply to the newsgroup. The email account listed in my From
      header is my spam trap, so I don't check it very often. You will get a
      quicker response by posting to the newsgroup.


        Comment

        • vinodkus@gmail.com
          #3
          Re: call storedprocdeure from asp

          On Sep 25, 6:55 pm, "Bob Barrows [MVP]" <reb01...@NOyah oo.SPAMcom>
          wrote:
          Change the cursortype to adUseClient
          >
          >
          >
          >
          >
          vinod...@gmail. com wrote:
          dear sir/madam
          >
           I have created a stored procedure using if and else if. this stored
          procedure only select
          record from table. and I have done paginh\g in asp page.
          so It gives error
          like
          >
          ADODB.Recordset error '800a0cb3'
          >
          Current Recordset does not support bookmarks. This may be a limitation
          of the provider or of the selected cursortype.
          >
          /Tiecon/request_meet.as p, line 613
          >
          error line no is
          >
          rs.AbsolutePage = currentpage
          >
          I think calling of this stored proceudure is somethig different method
          I m calling like this
          >
          rs.CursorType=a dOpenStatic
          rs.open sql,conn
          pagecount = rs.pagecount
          >
          please tell me what is the problem
          >
          Thanks in advance
          >
          --
          Microsoft MVP -- ASP/ASP.NET
          Please reply to the newsgroup. The email account listed in my From
          header is my spam trap, so I don't check it very often. You will get a
          quicker response by posting to the newsgroup.- Hide quoted text -
          >
          - Show quoted text -
          sorry same error message display again

            Comment

            • Anthony Jones
              #4
              Re: call storedprocdeure from asp

              <vinodkus@gmail .comwrote in message
              news:d1db095a-4a5a-4995-abf9-0b4903126958@a3 g2000prm.google groups.com...
              On Sep 25, 6:55 pm, "Bob Barrows [MVP]" <reb01...@NOyah oo.SPAMcom>
              wrote:
              Change the cursortype to adUseClient
              >
              >
              >
              >
              >
              vinod...@gmail. com wrote:
              dear sir/madam
              >
              I have created a stored procedure using if and else if. this stored
              procedure only select
              record from table. and I have done paginh\g in asp page.
              so It gives error
              like
              >
              ADODB.Recordset error '800a0cb3'
              >
              Current Recordset does not support bookmarks. This may be a limitation
              of the provider or of the selected cursortype.
              >
              /Tiecon/request_meet.as p, line 613
              >
              error line no is
              >
              rs.AbsolutePage = currentpage
              >
              I think calling of this stored proceudure is somethig different method
              I m calling like this
              >
              rs.CursorType=a dOpenStatic
              rs.open sql,conn
              pagecount = rs.pagecount
              >
              please tell me what is the problem
              >
              sorry same error message display again
              >>>>
              Since this an error to do with the provider do you think it might be an idea
              to specify which provider you are using?

              Are you sure a rowset is being returned form the SP?


              --
              Anthony Jones - MVP ASP/ASP.NET

                Comment

                Previous template Next
                Working...