Error: "Invalid SQL Query"

From Sage Intelligence Knowledgebase
Revision as of 06:31, 11 November 2014 by Support (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


Sage 100 ERP


Error: "Invalid SQL Query" occurs in Sage 100 Intelligence


Backup Warning

Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage Business Partner, network administrator, or Sage Customer Support Analyst.

Network Warning

This solution requires advanced knowledge of your network. Contact your system administrator for assistance. Modifying Windows security incorrectly can severely affect system operations. Sage is not responsible for operation issues caused by incorrectly modifying your Windows security. Always create a backup of your data before proceeding with advanced solutions.


Corrupted sqlceoledb35.dll file


  • In Add/Remove Programs, uninstall any Sage Intelligence (SI) hotfixes that were installed in attempt to fix this issue.
  • Delete the file ALUNISQL.dll from the SI installation folder and repair SI so that it has the default file back in place.
  • Locate this file. C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sqlceoledb35.dll or if using 64-bit machine go to C:\Program Files(x86)\Microsoft SQL Server Compact Edition\v3.5\sqlceoledb35.dll
  • Right click on sqlceoledb35.dll file and select Open With, Choose default program
  • Click Browse button
  • Browse to C:\Windows\System32\regsvr32.exe or if using 64-bit machine, browse to C:\Windows\SYSWOW64\regsvr32.exe
  • Click Open then click Ok
  • Click Ok to the prompt the file was successfully registered


Sage 100 ERP

Defect ID

Defect 103249, ALCH 19581