Create Pervasive ODBC Driver DSNs for 64bit SQL Server

For CYMA customers that will be using both Pervasive 64bit and SQL Server 64bit, you will need to manually create the Pervasive ODBC DSNs. By default, Acctivate will create the 32bit DSNs, which will not be compatible with the 64bit architecture of Pervasive and SQL Server.

  1. On Server, verify both SQL Server and Pervasive are x64
  2. Open Control Panel -> Administrative Tools -> ODBC Administration
  3. Select the System DSN tab.
  4. Select to Add a new DSN.
  5. Select the Pervasive driver, then enter in the name of the CYMA database (CYMA2Demo, CYMADemo, Demo, CYMA2somecompany,…).
  6. Select the button at the bottom to list the databases. Select the corresponding database.
  7. Repeat these steps for each CYMA database.

 

Posted in Installation - Last modified on October 20, 2016Zach Allen
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.