Re: how to allow multi-rec.set results ?

Check the following links for more information on MARS:
http://blogs.msdn.com/dataaccess/archive/2005/08/02/446894.aspx
http://msdn2.microsoft.com/en-us/library/ms130978.aspx

-Sue

On Mon, 17 Jul 2006 12:04:24 -0300, "bajopalabra"
<bajopalabra@xxxxxxxxxxx> wrote:

hi
until today, with sql2000 i get recordsets connecting with
"Provider=sqloledb;Data Source=myServer;Initial
Catalog=myDB;Integrated Security=SSPI"

but now, having migrated to sql2005
i use
"Provider=SQLNCLI;Server=myServer;
Database=myDB;UID=xx;PWD=yy"

i get the ERROR "Current provider does not support
multiple recordsets from a single execution"

wich provider should i use ??

thanks

.

Loading