RE: monitoring database

From: joe mamma (joemamma_at_discussions.microsoft.com)
Date: 03/17/05 

Date: Thu, 17 Mar 2005 07:33:04 -0800

not sure what you are asking here, so let me ask you. . .

What do you mean by 'detect a lost connection' ?
You shouldn't have a connection open except retrieve data or post changes
back. if the connection breaks it throws an exception.

It is a big, yet common, mistake to leave your connections open.

Open your recordset, Disconnect it from the connection, close the connection.
Make changes to your recordset, reopen the connection, reconnect the
recordset and update.

If your design calls for a constant connection, I argue you need to redesign.

Relevant Pages

  • Re: Updating Access data using SQL / refresh time question
    ... As a test today, for one poarticular recordset, I changed from DAO to ADO to ... > I forgot to mention that the expense of repeated connection open and close ... > dim oconn as new adodb.connection ... > 'Now load the listview by looping through each RS row ...
    (microsoft.public.vb.database)
  • Re: Updating Access data using SQL / refresh time question
    ... > I forgot to mention that the expense of repeated connection open and close ... > dim oconn as new adodb.connection ... > 'Now load the listview by looping through each RS row ... > ' Set the recordset object each time we load the listview ...
    (microsoft.public.vb.database)
  • Re: Problem: MDB-Datenbank Zugriff über das Intranet
    ... Wie und wo öffnest Du Deine Connection zur *.mdb? ... > End With ... Du öffnest ein Recordset mit adOpenForwardOnly. ... Datensatz liegenden Datensatz zuzugreifen. ...
    (microsoft.public.de.vb.datenbank)
  • Re: ASP - FROM statement slows down connection to database
    ... Open your database in Access, switch to the Queries tab, create a new query ... in Design View without choosing a table, swtich to SQL View, paste the sql ... connection string rather than using an ... recordset open statements. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Can Not Create Control
    ... > Private Sub Form_Load ... > Dim laco As Connection ... > Dim lars As Recordset ...
    (microsoft.public.pocketpc.developer)