User Tools

Site Tools


gb9dxcu.htm
Navigation:  SQL Drivers > ODBC Accelerator Driver >====== ODBC:Overview ====== Previous pageReturn to chapter overviewNext page

The ODBC Acclerator Driver is one of several SoftVelocity SQL Accelerator drivers. These SQL Drivers share a common code base and many common features such as SoftVelocity'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 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.

NoteBox.jpg

Make sure you have the latest ODBC drivers from your database server provider, as well as the end users of your applications.

gb9dxcu.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1