ODBC
CygNet provides an ODBC driver that acts as a translation layer between generic ODBC messaging and native CygNet messaging.
ODBC Messaging
CygNet clients use native CygNet messaging, which is very efficient. ODBC applications use the CygNet ODBC driver to translate generic ODBC messages into CygNet messages. Due to the translation, obtaining data using ODBC is less efficient than native messaging but is more efficient than COM/DCOM.
|
ODBC Messaging |
CygNet Reports uses ODBC to retrieve data. It is a thin wrapper around the Crystal Reports runtime engine. Crystal Reports is an ODBC application. The CygNet ODBC driver provides access to data stored in CygNet using any ODBC application such as Microsoft Access, Microsoft Excel, or Crystal Reports. ODBC can also be used for reporting or editing. SQL command-line statements have better performance than Microsoft Access; however, Access provides a better user interface. The CygNet ODBC driver includes an iSQL interface (from Open Access), which can be used to write SQL command-line statements. Any computer that uses the CygNet ODBC driver is a CygNet seat.
The CygNet Business Object Builder also uses ODBC to expose CygNet data in a virtual ODBC database. For more information, see Using Business Objects with ODBC.
ODBC Processing Performance
The ODBC application could negatively affect performance of the computer due to either the volume of data the application is requesting or to a poorly structured query. If the request is made from a client computer, the host would not be affected due to the fact that the ODBC processing is done on the local computer and the host is simply responding to CygNet messages. For this reason, CygNet Software does not recommend using ODBC applications on the host. If a client computer has its performance impacted, only one user is inconvenienced whereas if the host server were to experience similar degraded performance all users could be inconvenienced (for instance, polling is stopped).
To address questions or circumstances beyond the scope of the CygNet Help, Additional CygNet Resources are available.
More:
