Data Controls and Server Connections 
Author Message
 Data Controls and Server Connections

Hi

        I have a global Database object to which i OpenDatabase a
        connection to a remote MS SQL Server when the MDI form loads.
        I have a form with 3 data control objects.On FormLoad I
        OpenRecordset on the global Database object, three recordsets
        and set them to the DataControl.recordset.
        I expect one login session on the SQL Server, but if i check
        by sp_who using isqlw , i see two login sessions ?
        why two ?

thanks

Sudhindra V. Deshpande                                    
Member Technical Staff,Database Division               Residence :
National Center for Software Technology,               D-6 408, Inlaks Park,
Gulmohar Cross Road No. 9,                             15 Yari Road,
Bombay   400 049                                       Andheri (West),
Tel: +91(22) 620 1606 Fax: +91(22) 621 0139            Bombay 400 061

http://www.***.com/ ~sudhin



Wed, 27 Oct 1999 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Connection string for DAO data control to SQL Server

2. ADO data control spawns new connection to SQL Server

3. closing ADO data controls and data environment connections

4. data control and remote data control

5. Create User Control as Data Source Using ADO Data Control

6. Data Control vs Remote Data Control (for Axx95 and VB4/32 Enterprise)

7. data control and remote data control

8. Help ! ADO data control and standard data control

9. Data controls or no data controls?

10. ADO Data Control, Connection Object Question

11. How to close a ADO Data Control Connection?

12. Data Control and DB-connections


 
Powered by phpBB® Forum Software