SQL Access in Pervasive.SQL

Starting with Pervasive.SQL 2000, ODBC replaced the Scalable SQL API as the data access method for SQL databases. This brings several advantages that should outweigh issues of migrating to this API. These includes the following:

Improved performance

Standards-based API

Central to Pervasive's replication product

Oracle-Pervasive interoperability (see following section)

For developers currently using the Scalable SQL API, the Pervasive Library contains an Application Migration Guide (http://www.pervasive.com/library/index.asp?_shownode=MIG), which documents the issues Scalable SQL developers need to know in order to shift to ODBC-based relational database programming.

You do not have to learn the ODBC API in order to develop Pervasive.SQL applications. There are additional interfaces such as OLE DB or JDBC that can simplify development. For more information, see Chapter 19, ODBC Programming.