activex_data_objects thread: error trying to move to next recordset
Message #1 by "Tony" <one_dev@h...> on Wed, 20 Jun 2001 17:26:03 -0500
|
|
I'm calling a stored procedure and setting a recordset = the data returned
(which has multiple recordsets). I've done this many times before but for
some reason now I'm getting this error when trying to move to the second
Recordset:
"Current provider does not support returning multiple recordsets from a
single execution."
What's going on?
Thanks in advance for your help
Message #2 by "Simply Red" <simplyred@e...> on Thu, 21 Jun 2001 04:40:17
|
|
check your provider since not all providers support multiple recordsets,
also check your cursor location since it doesn't also support client-side
cursors
> I'm calling a stored procedure and setting a recordset = the data
returned
> (which has multiple recordsets). I've done this many times before but
for
> some reason now I'm getting this error when trying to move to the second
> Recordset:
>
> "Current provider does not support returning multiple recordsets from a
> single execution."
>
> What's going on?
>
> Thanks in advance for your help
>
>
>
>
>
Message #3 by "Tomm Matthis" <matthis@b...> on Thu, 21 Jun 2001 06:39:42 -0400
|
|
What is the database? And does it indeed support multiple recordsets?
If its SQL server, try adding "SET NOCOUNT ON" at the top of the sproc.
Hope that helps.
-- Tomm
> -----Original Message-----
> From: Tony [mailto:one_dev@h...]
> Sent: Wednesday, June 20, 2001 6:26 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] error trying to move to next recordset
>
>
> I'm calling a stored procedure and setting a recordset = the data returned
> (which has multiple recordsets). I've done this many times before but for
> some reason now I'm getting this error when trying to move to the second
> Recordset:
>
> "Current provider does not support returning multiple recordsets from a
> single execution."
>
> What's going on?
>
> Thanks in advance for your help
>
>
>
>
>
>
> matthis@b...
> $subst('Email.Unsub')
>
>
Message #4 by "Tony" <one_dev@h...> on Thu, 21 Jun 2001 08:50:47 -0500
|
|
Thanks for the help.
I am using MS's oledb provider for odbc.
Well, for some reason now it's working........???
"Tony" <one_dev@h...> wrote in message
news:75776@a..._data_objects...
>
> I'm calling a stored procedure and setting a recordset = the data returned
> (which has multiple recordsets). I've done this many times before but for
> some reason now I'm getting this error when trying to move to the second
> Recordset:
>
> "Current provider does not support returning multiple recordsets from a
> single execution."
>
> What's going on?
>
> Thanks in advance for your help
|
View Cart
