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|
*Pervasive.SQL v11.0 or later