p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

activex_data_objects thread: Re: error trying to move to next recordset


Message #1 by "Mike McCrossin" <mike8845@h...> on Tue, 17 Jul 2001 10:44:01 -0500
What is meant by the word "provider"?



that is all for now... mikeM





>From: "Simply Red" <simplyred@e...>

>Reply-To: "ActiveX_Data_Objects" <activex_data_objects@p...>

>To: "ActiveX_Data_Objects" <activex_data_objects@p...>

>Subject: [activex_data_objects] Re: error trying to move to next recordset

>Date: 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 #2 by "Reed Mohn, Anders" <Anders.Reed.Mohn@i...> on Tue, 17 Jul 2001 18:20:31 +0200

Your data provider, i.e. where you get your data from.

Not the database, but the mechanism that delivers the data

to you.

For instance, underneath ADO, there's a set of OLE DB providers

for connection to various data sources/DBMSs



Anders :)







> 

> What is meant by the word "provider"?

> 

> that is all for now... mikeM


  Return to Index