ODBC Interface to Query VTS History
The ODBC Interface to VTS History provides a means to create and view live reports from a VTS application, using programs such as Crystal Reports, Access or Excel. One of its main advantages is that the computer querying the application need not have VTS installed. Managers, engineers, operators etc. can view up-to-date reports from any location without needing to install VTS on the remote computer.
Through this interface, you can treat a VTS application as if it were a database, with each logged tag within it representing a table of timestamps and values. Once the connection is configured, your reporting program can send SQL queries to VTS to retrieve tag values that are being logged. (Tags that are not being logged will have no stored history to query.)
Note that you will need to install the VTS ODBC Drivers on any computer that is to display the reports, by running the program VTSODBCDriverInstall.exe.
Before proceeding, check that your copy of VTS is licensed for the ODBC server by clicking on the About VTS button in the VAM.
The steps required to configure your application as an ODBC Server, and to set up your desktop computer to view the data, are described in the following sections.
Configuring Your Application to be an ODBC
Server
Connecting to Your Application
Data Available to the ODBC Interface
ODBC Interface: Table Structure