469,904 Members | 2,035 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,904 developers. It's quick & easy.

ADO Error 3251: Current provider does not support returning multiple recordsets from a single execution?

I've got another stored procedure in the same app that returns multiple
recordsets and the code works.

But now I've written another SP and the code traps out with the 3251 message.

The SP is writing two recordsets, but when I step through the code, when the
first RS should be there, it's "Closed" and nothing I've tried will make it
open.

Seems like I've been here before, but I can't remember what the problem was.
--
PeteCresswell
Nov 12 '05 #1
2 3298
I should add that when I run the SP in Query Analyzer, both recordsets appear.
--
PeteCresswell
Nov 12 '05 #2
And that:

Provider=SQLOLEDB.1

(which works on the other screen...)
--
PeteCresswell
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Steve | last post: by
6 posts views Thread by Peter Frost | last post: by
6 posts views Thread by Chris Love | last post: by
3 posts views Thread by amatuer | last post: by
2 posts views Thread by slinky | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.