ODBC Architecture

There are basically two types of ODBC architecture: those that involve multiple tier ODBC drivers and single tier ODBC drivers.

Multiple tier drivers are more common, and are typically used with a remote database server such as Oracle® and SQL Server. Multiple tier ODBC drivers process ODBC calls made by the application, but pass the actual SQL command to the database system.

Single tier drivers, such as the Microsoft® Access® driver, often operate directly on a database file or files. A single tier ODBC driver processes both ODBC calls and the actual SQL commands. In most cases, a configuration using a single tier driver can be contained on just one computer.

See Also

Important Notice

You do not have the latest version of iFIX! You are missing out on the newest capabilities and enhanced security.

For information on all the latest features, see the iFIX product page.

For more information on upgrades, contact your GE Digital sales agent or e-mail GEDigitalSalesSupport@ge.com.

For the most up-to-date documentation, go here.