INFORMATIONAL ** THIS INFORMATION HAS NOT BEEN VERIFIED **

"Failed to create SQL Compact Edition database  Error: Opening a database as a read-only requires a temp path to be specified..." in Sage MAS Intelligence

Entry Type: Informational

Product: Sage ERP MAS Intelligence

Application: Report Manager

Version Reported: 4.40

Subject:

"Failed to create SQL Compact Edition database  Error: Opening a database as a read-only requires a temp path to be specified.  [path] Number: -2146233088 Driver Error: Unknown SQL State: Unknown" in Sage MAS Intelligence after the Sage MAS 90 and 200 Intelligence Performance Patch has been installed.

Possible Resolution:

Sage MAS Intelligence for Sage MAS 90 and 200:

The Performance Patch was not installed properly:

  1. Using Control Panel / Add/Remove Programs, uninstall the Microsoft SQL Server Compact 3.5
  2. Double-click on the Sage MAS 90 and 200 Intelligence Performance Patch_1.00.0021.exe
  3. Select the Remove option
  4. Double click on the Sage MAS 90 and 200 Intelligence Performance Patch_1.00.0021.exe to reinstall the Performance Patch

Related Links:

Sage MAS 90 and 200 Intelligence Performance Patch_1.00.0021.exe