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

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