call storedprocdeure from asp

[vinodkus]

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.asp, 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=adOpenStatic
rs.open sql,conn
pagecount = rs.pagecount

please tell me what is the problem

Thanks in advance

[Bob Barrows [MVP]]

Change the cursortype to adUseClient

vi******@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.asp, 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=adOpenStatic
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.

[vinodkus]

On Sep 25, 6:55*pm, "Bob Barrows [MVP]" <[e-mail]>
wrote:

Change the cursortype to adUseClient

[e-mail] 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.asp, 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=adOpenStatic
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

[Anthony Jones]

<vi******@gmail.comwrote in message
news:d1**********************************@a3g2000p rm.googlegroups.com...
On Sep 25, 6:55 pm, "Bob Barrows [MVP]" <[e-mail]>
wrote:

Change the cursortype to adUseClient

[e-mail] 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.asp, 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=adOpenStatic
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