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


.

Relevant Pages

  • Re: Cannot start services
    ... | Computer: COUNTYG ... see Help and Support Center at ... | A provider, PerfProv, has been registered in the WMI namespace, ... | will be run using the LocalSystem account. ...
    (microsoft.public.windows.server.general)
  • Re: How to get tables/views/columns in ODBC (& OleDb)
    ... Understanding the Common Schema Collections ... (OLEDB/ODBC/ Microsoft .NET Framework Data Provider). ... and filter the outputs by ... Microsoft Online Community Support ...
    (microsoft.public.data.odbc)
  • RE: Server Performance Report: "No data is available for this sect
    ... There is no data in the entire report. ... This provider will be run using the LocalSystem ... see Help and Support Center at ... >> performance data buffer. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS Restarting!! DS Promotion? and Other such problems
    ... I have come inthis morning to find that Our SBS server is powered down.... ... see Help and Support Center at ... This provider will be run using the LocalSystem ... SBS 2003 - Admin ...
    (microsoft.public.windows.server.sbs)
  • Re: How to get tables/views/columns in ODBC (& OleDb)
    ... Understanding the Common Schema Collections ... (OLEDB/ODBC/ Microsoft .NET Framework Data Provider). ... and filter the outputs by ... Microsoft Online Community Support ...
    (microsoft.public.data.odbc)
Loading