Re: ADO Connection Failure

From: Andrew (abaylis_nos_at_spamcop.net)
Date: 01/21/04

  • Next message: Khashayar IranParast: "Re: Login form is not responsive when connecting to the DB" 
    Date: Wed, 21 Jan 2004 15:54:17 +1100

    "Keith Comley" <klcomley@ntlworld.com> wrote in message
    news:400d9ee6@newsgroups.borland.com...
    > Second Question - Does anyone know of a way to reestablish the
    ADOConnection
    > without Closing all of the active Queries using that connection?
    >
    > Thanks for all your help,
    > Todd"
    >
    >
    If the active queries have client-side cursors, it is (in theory) possible
    to turn them into disconnected recordsets, open another connection and then
    reconnect them. The lock mode (I think) needs to be batchoptimistic so that
    changes made while disconnected can be cached.
    If all you want to do is replace one ConnectionObject with another, you'll
    have to look within the source code, but it should be possible with some
    tinkering.
    Cheers,
    Andrew

  • Next message: Khashayar IranParast: "Re: Login form is not responsive when connecting to the DB"

    Relevant Pages

    • Re: Included function not always found.
      ... disconnected recordsets, would be more efficient. ... a connection on the page. ... > Connection pooling assists you on a page by page basis. ... > set conn = nothing ...
      (microsoft.public.inetserver.asp.general)
    • Disconnected recordset
      ... I am using disconnected recordsets, though I notice that a serverside ... cursor is used whenever retrieving recordsets through the second ... When retrieving data over the first connection, ...
      (microsoft.public.data.ado)
    • Re: Transferring information between disparate connections using ADO.
      ... I've never tried it, but since ADO supports disconnected recordsets, you ... Microsoft Access 2003 VBA Programmer's Reference ... the information into connection B, ...
      (microsoft.public.access.modulesdaovba)
    • Re: Access -- Leave ADO connection open?
      ... My experience is with SQLServer and ADO, and I typically open and close ... the database connection with each i/o, and use disconnected recordsets. ...
      (microsoft.public.vb.general.discussion)
    • Re: When to Close the Connection?
      ... > of the sql server, does mine doubt the following it is, because I see ... > modulate has the connection with the bank.... ... Leaving a connection "connected" does use some small amount of memory on ... efficiently with more than 5active queries, ...
      (microsoft.public.sqlserver.programming)