closing VB6 ADO recordset takes much too long with SQL Server 2005

We are creating a Forward Only Server Side recordset. This enables us
to respond pretty quickly to user searches. As soon as we have access
to the first record, we start populating a listview with the results,
but if the result has more then X records we ask the user if he wants
to continue or not. If he wants to stop, we just close the recordset.
Closing the recordset is instantaneous, when we are using SQL Server
2000. But with SQL Server 2005, if the result contains a lot of records
and we try to close the recordset, it takes a long, long time
(depending on the number of results). It seems like the recordset is
going through all the records in the server cursor before closing. That
is not the behaviour with SQL Server 2000.

Does anyone have any hint on this?

Thanks for your help
JOEL

.

Relevant Pages

  • Re: AcXP MS-SQL --> Sperrungen
    ... Wenn Du ein Recordset aufmachst ruft Access zunächst alle Primärschlüssel ... Und der SQL Server verwendet Fällen, wo alle Daten einer Tabelle ...
    (microsoft.public.de.access.clientserver)
  • RE: TransferText from a table with a selection-parameter
    ... > temporary table where I store the recordset inside because there may be ... Each of your users can use separate temp tables in your SQL Server database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: VB-ADO-SQL Server : SQL Server performs logins after some queries
    ... The reason that I use Object types is that my code should work ... with a SQL Server 2K database (at a internet server) as well as MS Access ... recordset to a ADODB.recordset or a DAO recordset prior to creating the ...
    (microsoft.public.vb.database.ado)
  • Re: Was ist schneller und DB-verträglicher - FIND oder SELECT ?
    ... Dein Code ist insofern performant, ... Ich würde mir ALLE Daten in ein lokales RecordSet holen und dieses RecordSet ... Set cmd = New ADODB.Command ... ' Verbindung zum Server trennen... ...
    (microsoft.public.de.sqlserver)
  • Re: Zugreifen auf eine Stored Procedure
    ... >> wie kann ich denn auf eine Stored Procedure die auf dem SQL Server ... Die Stored Procedure soll mir eine Recordset ... > User und Passwort sind Eigenschaften der Verbindungszeichenfolge ...
    (microsoft.public.de.sqlserver)