Skip to content

New Connectivity Kits

The introduction of RowId brings along a new revision of SQL Connectivity Kits (revision 4.x), including builds for Microsoft SQL Server, IBM DB2, and ODBC. While the Pervasive.SQL Connectivity Kit is not impacted directly by RowID (its transactional API maps directly into the recnum style of programming and database access), there is also a new revision (3.x) that has additional features. The DataFlex Studio installation includes the option to install all of the latest connectivity options.

As there are various revisions of products and connectivity options that can be combined, it's important to understand what combinations are supported and what capabilities will be enabled.

If your environment is DataFlex 11.0...

If your environment is DataFlex 10.1 (and older) or DataFlex 3.2 Console Mode...

If Connectivity Revision is 3.x...

  • Tables must be recnum-enabled (a single-column, numeric unique identifier) in order to be used "natively" (with full data dictionary support).
  • Embedded SQL can be used to access standard tables (without a unique, numeric identifier).

If Connectivity Revision is 4.x...

  • Tables can be either standard or recnum-enabled. The type of table you use determines the programming style options you have.
  • Tables must be recnum-enabled (a single-column, numeric unique identifier) in order to be used "natively" (with full data dictionary support).
  • Embedded SQL can be used to access standard tables (without a unique, numeric identifier).