| Previous | Next |
| ERROR_PRODUCT_UNINSTALLED | ERROR_INVALID_FIELD |
ERROR_BAD_QUERY_SYNTAX
ERROR_BAD_QUERY_SYNTAX means that Windows Installer rejected the SQL statement used to query an MSI database. Windows Installer SQL is a restricted database-query language, so general SQL syntax from another database engine may not be valid.
Capture the exact MSI SQL string after quoting and parameter construction, then test it against the Windows Installer database schema. Rewrite the query using MSI SQL rules instead of carrying syntax from SQL Server, SQLite, or another engine.
What to check
- Record the exact query text and the table or view it was intended to access.
- Check identifiers, quoting, field names, and supported SQL constructs against the Windows Installer database API.
- Do not convert a query failure into an empty result; that can hide a package-authoring defect.
Microsoft: Windows Installer error codes · Microsoft: MsiDatabaseOpenView
Looking for a different code? Search another status or error code.