Support for 64-bit editions of Microsoft SQL Server and/or Pervasive.SQL (CYMA)

The following article only applies to the CYMA version of Acctivate.  The ODBC driver is used by Microsoft SQL Server to “link” to Pervasive.SQL and the architecture (i.e. 64-bit) must match.

  • 32-bit version of Microsoft SQL Server requires 32-bit Pervasive.SQL ODBC driver
  • 64-bit version of Microsoft SQL Server requires 64-bit Pervasive.SQL ODBC driver

Pervasive did not include a 64-bit ODBC driver for the Relational engine until Pervasive v11.0.  Pervasive v11.0 64-bit edition is supported by Acctivate and CYMA version 13 or later.  The 64-bit version of Microsoft SQL Server is required, since the “bitness” must match.

Please be aware that 32-bit versions of Pervasive.SQL and Microsoft SQL Server are fully supported on 64-bit Windows operating systems.

The following table lists the supported environments for Acctivate:

Microsoft Windows Pervasive.SQL Server Microsoft SQL Server
32-bit 32-bit 32-bit
64-bit 32-bit 32-bit
64-bit 64-bit* 64-bit

*Pervasive.SQL v11.0 or later

Posted in Database, Installation - Last modified on May 30, 2019
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support ticket.