Error Message "Cannot open SQL"

stone

Issue
Error Message "Cannot open SQL" May Appear When Printing Reports in Accpac ERP


Special Considerations or Warnings
None.



Solution or Workaround
In Pervasive.SQL version 8.6, 9.1 and 9.5, by default, database security is turned off on newlycreated databases. Once the security is turned on for a particular database, users need to supplya username and a password in order to open up the PVSW tables.This may cause problems withprinting reports.

We start to support Pervasive.SQL security in Sage Accpac ERP version 5.4.
Turn security off to when printing reports in previous versions of Sage Accpac ERP.