ADO Recordset Cursor Types & Connections Question 
Author Message
 ADO Recordset Cursor Types & Connections Question

I am building an MDI app in VB that will run against a SQL Server database.
The user will be able to have potentially several forms open at any given
time each of which will be displaying a different result set from the
database.  I am using one global connection object in the project and
several recordsets (usually 1 per form).

I was initially opening my recordsets without specifying the cursor type
(default).  But when monitoring the database I noticed that this would
create multiple connections to the database (1 per recordset).

Now if I specify my cursors' types as adOpenDynamic I don't see this
behavior.  With all the record sets opened there is still only one
connection registering on the database (which is of course what I prefer).

What I don't understand is why specifying a dynamic cursor type would make
this difference over say a static cursor type?

Anyone know?

- Dan

Wed, 02 Oct 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. ADO cursor location and cursor type question

2. ADO, OLE DB and Oracle - can't addNew to recordset, wrong cursor type

3. Help Reqd: ADO Recordset changes Cursor Type Dynamically

4. Connection cursor location vs. Recordset cursor location

5. ADO cursor type question

6. Question about ADO cursor type?

7. ADO fails to release Recordset cursor after opening disconnected Recordset

8. cursor type and connection mode

9. Collection of ADO Recordsets and/or ADO Connections

10. Recordset, changing cursor type

11. Recordset, changing cursor type

12. ADO Connection & ADO FillDataSet


Powered by phpBB® Forum Software