send connection status via ODBC to database

[Toot]

Arthur,

Is there a way to send a bit to a database field via ODBC to check if the TCP connection is still up between serial converter and TCP/IP datalogger software? Maybe even better if this is live signal available with DDE via network. I would like to be able the check connection status via my VBA for Access GUI. I have four different IP's that i'm listening to. I would like to show status with red or green dot for quick visual purpose.

Thanks,
Otto

[Arthur Grasin]

Hello, Otto,

Unfortunately, I can only suggest to read and parse a program protocol file for Open/Close messages.