Abstract: General
information about how the ODBC mechanism works
in Statit 5.x.
Products:
Statit
e-QC, Statit
e-Server, Statit
Custom QC, Statit
Express QC
The title How it Works is a bit grandiose
for the real intent of this document. Rather,
take this document as an overview of how Statit
interfaces with ODBC.
Overview
Statit ODBC code talks to the ODBC Driver Manager
installed on your system. The Driver Manager
talks to the ODBC Driver for the Data Source
you have defined. The Driver sends the connect
string or query to the Database and retrieves
the results.
Getting It Working
You start by defining a Data Source using the
ODBC Administrator. The Administrator is available
from the Control Panel, or from the "Select
a Data Source" dialog, the New or Admin
buttons of Statit Custom QC and Statit Express.
Once the Data Source is defined, you connect
to it using the Statit selection File|Import|Connect
to Database, which brings up the "Select
a Data Source" dialog.
Correctly defining a Data Source is pretty
intuitive when using the Administrator. It is
beyond the scope of this document to go into
details. Just note that the ODBC Driver you
use may have to be purchased from the vendor
of the database you wish to access.
Requirements
These requirements are mostly handled by Statit's
installation and by the ODBC Driver Manager.
They are noted here for your information in
the event of a problem.
What You May See
The code generated by Statit's Query Tool (Statit
Custom QC or Statit Express) is SQL which meets
the specifications for ODBC Level 3. Thus, you
may see some things which look a bit strange
if you are used to the specific SQL for your
database. ODBC is a more generic means of communicating
to a variety of databases, so the standard for
ODBC code differs slightly from generic SQL
code.
In generating the Where Clause, if you test
against a date value, Statit will generate a
date value of the following form:
