• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 405
  • Last Modified:

ADO and stored proc

Hi,
I am having a very serious problem using ADO with stored procedure. I am
using Microsoft’s ADODB_TLB. I have written a stored procedure with a
simple select st. I use recordset and get those values. But I am getting
an error when I use
            Recset.Aboslutepage
Error -     “operation requested by the application is not supported by
the provider”
It works perfectly in VB or ASP. I got the same error when I used
command obj.What can be the problem? Please let me know
                         Thanking you,
                             Gold

0
manjushan
Asked:
manjushan
  • 3
  • 2
1 Solution
 
Michael_Benjamin_PerezCommented:
It depends on the opening of the Recordset (adOpenForwardOnly, adOpenDynamic, adOpenKeyset) check the necessary documentation.

When using Recset.AbsolutePage you'll probably need to open it with adOpenDynamic.

In VB it probably works because of the default parameters... (it uses adOpenDynamic as default).

Good luck !
0
 
manjushanAuthor Commented:
hi,
  If I use RecSet.Open('select * frm assa,connstr,3,3,0) then
  RecSet.AboslutePage is workinf correctly.This problem is there only for stored procedures
0
 
Michael_Benjamin_PerezCommented:
The last zero specifies the parameter adCmdText, when using stored procedures it's handy to use the const adCmdStoredProc (which is 3).

Try it !
0
 
manjushanAuthor Commented:
Hi Michael,
  Thanks its working fine.
                Manju
0
 
Michael_Benjamin_PerezCommented:
Great !

Now let's hope for better documentation of ADO.

Ciao

Mick.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now