How do I?
Does Acctivate Support 64-bit Editions of Microsoft SQL Server and/or Pervasive.SQL (CYMA)?
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
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