Re: Lost connection


"BlueGI" <giwachow@xxxxxxxxxxx> schreef in bericht news:4683b04a@xxxxxxxxxxxxxxxxxxxxxxxxx

Why not have a common Open/Exec method that has logging, retries and exception handling?
That way the only change is to call this method whereever the other queries call their
own Open or ExecSQL statements. The retries would be triggered by an exception, which
would close and reopen the connection before trying again without the user knowing
anything. Large systems should have a common logging area. Makes debugging much
easier.

That's how I implemented the last data access layer. Implicit reconnects, and not one
application how will notice (other than a longer than usual delay before data is
returned)....

....Arjan...


.