©
National Instruments Corporation
B-1
B
Citadel and Open Database
Connectivity
This appendix describes the Citadel database and the Open
Database Connectivity (ODBC) driver, and includes a table that
lists data transform commands.
The Citadel historical database includes an Open Database Connectivity
(ODBC) driver. This driver enables other applications to directly retrieve
data from Citadel using Structured Query Language (SQL) queries.
To use the SQL ODBC interface to Citadel, you must have installed
the Citadel ODBC driver from the BridgeVIEW CD.
What is ODBC?
ODBC is a standard developed by Microsoft. It defines the mechanisms
for accessing data resident in database management systems (DBMSs).
Virtually all Windows-based applications that can retrieve data from a
database supporting ODBC.
Because Citadel allows simultaneous real-time access by multiple
applications, the ODBC Driver can retrieve data from the Citadel database
even while BridgeVIEW is running. There is no need to interrupt data
collection in order to query the database. In fact, the ODBC Driver allows
multiple ODBC applications to perform SQL queries simultaneously.
Configuring the ODBC Driver
1.
Shut down all applications that currently might be using ODBC. Such
applications include spreadsheets, word processors, database
programs, MS Query, etc. You do not need to shut down BridgeVIEW.
2.
Click the Start button, point to Settings, then click Control Panel.
Otherwise, in the Main program group, choose the Control Panel icon.
3.
In the Control Panel dialog box, choose the 32-bit ODBC.
4.
In the Data Sources dialog box, choose Drivers….
