Versions Compared

Old Version 1

changes.mady.by.user SRP Support

Saved on

compared with

New Version Current

changes.mady.by.user Corby Nagel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The CS_SPY window shows the status of client/server connections, datasets, and bound forms.   You You can run the form by highlighting the CS_SPY entry in the Repository Outliner (under OpenInsight Form Executables)  and and pressing SHIFT-doubleclick.   The The CS_SPY Connections window when the PUBS ODBC connection to SQL Server is active displays similar to that shown below:

...

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 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 For example, two instances of the Query Designer window can be active, one connected to Access and another connected to SQL Server.  Each Each will have a different Connection Handle.  Select Select from the Connection Handle dropdown to monitor each connection.