By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,222 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,222 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
I should add that when I run the SP in Query Analyzer, both recordsets appear.
--
PeteCresswell
Nov 12 '05 #2

P: n/a
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.