bajopalabra

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,
Hernán

sue hoegemeier

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