Error: "Invalid SQL Query"
Sage 100 ERP
Error: "Invalid SQL Query" occurs in Sage 100 Intelligence
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.
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 103249, ALCH 19581