The CS_SPY window shows the status of client/server connections, datasets, and bound forms. You can run the form by highlighting the CS_SPY entry in the Repository Outliner (under OpenInsight Form Executables) and pressing SHIFT-doubleclick. The CS_SPY Connections window when the PUBS ODBC connection to SQL Server is active displays similar to that shown below:
To monitor communication between OpenInsight and the back end databases it is communicating with, run the CS_SPY window and observe the changes as your client/server programs are running.
If there is a valid Connection Handle and a valid hQry (integers greater than 0), then the connection is active and ready for queries. The General Details area provides additional details (for example, if XO_USETRANS$ is set, changes to the database will not be applied until the transaction is committed).
More than one connection can be active. For example, two instances of the Query Designer window can be active, one connected to Access and another connected to SQL Server. Each will have a different Connection Handle. Select from the Connection Handle dropdown to monitor each connection.
