ERROR_BAD_QUERY_SYNTAX 1615 The SQL query syntax is invalid or unsupported
ERROR_BAD_QUERY_SYNTAX 1615 The SQL query syntax is invalid or unsupported.
I want to manipulate a .msi installer using MSI Database Open View but I received an error. Can this be diagnosed?
When invoking MixDatabaseOpenView, the process returns the error code 1615. This is an ERROR_BAD_QUERY_SYNTAX. This is the following data from calling MsiGetLastErrorRecord for more details and passing the resulting handle to MsiFormatRecord:
1: 2237
2: C:pathtomyinstaller.msi
3: INSERT INTO `ServiceInstall`
  (`ServiceInstall`,`Name`, `DisplayName`, `ServiceType`, `StartType`,
   `ErrorControl`, `LoadOrderGroup`, `Dependencies`, `StartName`,
   `Password`, `Arguments`, `Component_`, `Description` )
  VALUES
  ('ServiceInstall.ServiceName','ServiceName' ,'My Service' , 16 , 2 ,
   1 ,'' ,'' ,'' ,'' ,'' ,'C__E2E295F8B94A1C97F5DA47AACC498002' ,
   'My Service Description' )
4:
2237- this is a windows installer error message number that corresponds to "Invalid or missing query string" consistent with ERROR_BAD_QUERY_SYNTAX.
However the query string seemed to be fine. It isn’t missing as the data is provided back from MsiGetLastErrorRecord, it follows the proper formatting, and columns match the valid columns. Any ideas on what may be causing this operation to fail and how it may be resolved?