how to allow multi-rec.set results ?

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
atte,
HernnCheck the following links for more information on MARS:
http://blogs.msdn.com/dataaccess/ar.../02/446894.aspx
http://msdn2.microsoft.com/en-us/library/ms130978.aspx
-Sue
On Mon, 17 Jul 2006 12:04:24 -0300, "bajopalabra"
<bajopalabra@.hotmail.com> 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