|
The CONNX ODBC (Open Database Connectivity) Driver is a
dynamic-link library that applications can call to access data located in remote
systems. Coupled with the CONNX Data Dictionary, the ODBC Driver provides a means
of using many popular off-the-shelf querying tools and application development
tools. The driver works with ODBC-compliant software, which increases its
flexibility when used by companies with a range of front-end applications.
The ODBC interface enables database access to
database management systems using Structured Query Language (SQL) as a standard.
ODBC Driver Architecture
The architecture of the ODBC Driver has four components:
|
|
|
Application
|
|
|
|
Performs processing and calls ODBC functions to submit SQL statements
and retrieve results. See the online CONNX User Reference
Guide for a list of compatible ODBC-compliant applications.
|
|
|
|
|
|
|
|
Driver Manager
|
|
|
|
Loads drivers when requested by an application through a user-defined data source name (DSN).
|
|
|
|
|
|
|
|
Driver
|
|
|
|
Software that processes the ODBC function calls, submits the SQL requests
to a specific data source, and returns results to the application. If
needed, the driver changes an application’s request so that it conforms
to the syntax supported by the associated database.
|
|
|
|
|
|
|
|
Data Source
|
|
|
|
The data the user wants to access and its associated operating system,
DBMS, and the network platform (if any) used to access the DBMS.
|
CONNX ODBC Conformance
CONNX is an ODBC 3.51 driver. The CONNX driver supports all
core, level 1, and level 2 functions, including transaction functions, such as
COMMIT and ROLLBACK.
CONNX is also compatible with ODBC 3.x applications when
accessed through the normal ODBC driver manager, and OLE DB/ADO 2.x applications.
|
