The ODBC Acclerator Driver is one of several TopSpeed SQL Accelerator drivers.  These SQL Drivers share a common code base and many common features such as TopSpeed's unique, high speed buffering technology, common driver strings, and SQL logging capability.  See SQL Accelerator Drivers for information on these common features.  The ODBC Accelerator Driver converts standard Clarion file I/O statements and function calls into optimized SQL statements, which it sends to the backend SQL server for processing.  This means you can use the same Clarion code to access both SQL tables and other file systems such as TopSpeed files.  It also means you can use Clarion template generated code with your SQL databases.

The ODBC Acclerator Driver

The ODBC Accelerator Driver is slightly different from the other SQL drivers in that it is a generic SQL driver.   It is not specific to a particular SQL server, but, in fact, works with any database or file system that supports the ODBC standard.  This includes SQL systems such as AS400, Informix, MSSQL, Oracle, Scalable SQL, SQL Anywhere, Sybase, and many non-SQL systems as well (dBase, Excel, FoxPro, etc.).  This chapter describes special issues and considerations that arise when using the ODBC Accelerator Driver to access data.

All the common behavior of all the SQL Accelerator drivers is documented in the SQL Accelerator Drivers chapter. All behavior specific to the ODBC driver is noted in this chapter.

You must have Miscrosoft ODBC 2.1 or higher to access 32-bit data sources with Clarion's Database Manager or with a 16-bit application. Further, if the 32-bit data source is a Microsoft data source, you must also run Windows NT to access it with Clarion's Database Manager or with a 16-bit application.   You can download Miscrosoft ODBC 2.1 from ftp.sunet.se/ftp/pub/vendor/Microsoft/developr/ODBC/public/ODBC21.exe.