Easysoft ODBC-ODBC Bridge

Why does the ODBC-ODBC Bridge HTTP Server statistics page show active threads when there are no connections?

Article:
00061
Last Reviewed:
5th January 2024
Revision:
2

The Easysoft ODBC-ODBC Bridge HTTP Server statistics page is a guide to what is happening and what has happened in the ODBC-ODBC Bridge ODBC Server. The ODBC-ODBC Bridge Server registers a new active connection when a client successfully connects and a thread (or process) is started up to handle the ODBC connection. The server does not deregister the connection (as far as the statistics are concerned) immediately the client disconnects. The server looks for disconnected threads/processes when there has been no incoming connection for a period of 5 seconds. This gives priority to incoming connections. This also affects the peak concurrent connection count e.g. if you write a program which connects and disconnects in one second but this is repeated every 3 seconds the active connections and peak concurrent connections will appear to increase until your program stops.

There is one situation in which this is not the case. If you set MaxClientConnect or MaxThreadCount to a value other than 0 to limit the connections, the Server checks for terminating threads/processes every time a connection is made, so the active and concurrent counts will always be up to date immediately after an ODBC connection from a client.

This does not affect licensing in any way i.e. if you have a license limited to N concurrent connections the server does not use the active connections statistic to decide whether you can connect or not.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)