How to check if a connection is alive ?

Поиск
Список
Период
Сортировка
Искать
От
Andreas
Тема
How to check if a connection is alive ?
Дата
Msg-id
4004B79A.9030709@gmx.net
Список
Дерево обсуждения
How to check if a connection is alive ? Andreas <maps.on@gmx.net>
Re: How to check if a connection is alive ? Richard Huxton <dev@archonet.com>
Hi,

Access 2000
Postgresql 7.4.1
newest PG-ODBC

how can I check if a DAO- or ADO-connection is still alive ?
I'd like to maintain a connection to a remote PG server within my VBA code.
It should be opend when the users start the application and closed when 
the app terminates.
There are longer times while the application is idle and then some times 
when it hits the server very often.

E. g. I write a log in the DB where the app says who did when what.
I'd prefer not to strain the server and the LAN with permanent Conn 
Open/Close sequences.

There will be at least one external user who enters the LAN via a SSH 
tunnel over the internet.
This connection is naturally worse in responsivity than the internal LAN 
and there are chances that the tcp/ip connection breaks or the ODBC 
times out.

If Access runs into a stale connection it plays dead until it's ODBC 
timer runs out and that can take a while.
It would be better if I could check somehow wether the connection is 
still there, before sending a command over it.

Is there a way to do that ?


В списке pgsql-odbc по дате отправления
От: Sven Köhler
Дата:
Сообщение: psqlodbc msi version 7.3.200
От: Richard Huxton
Дата:
FAQ