Share via


Error Messages

Note

Indexing Service is no longer supported as of Windows XP and is unavailable for use as of Windows 8. Instead, use Windows Search for client side search and Microsoft Search Server Express for server side search.

 

Several errors can occur when submitting queries to the SQL parser. When these errors occur, the OLE DB Provider returns a DB_E_ERRORSINCOMMAND error (see ICommand::Execute). It can usually also return a string describing the error. These errors are usually syntax related.

The following error messages are not defined in a public header and the error codes associated with them are not exposed. They are also localized. Parameters shown in italics are specific to each query that is in error.

  • Parser Error
  • Illegal PASSTHROUGH query: Query_Expression
  • Incorrect syntax near Query_Token. SQLSTATE=42000
  • Incorrect syntax near Query_Token. Expected Token. SQLSTATE=42000
  • Multiple statement commands are not supported. SQLSTATE=42000
  • ORDER BY ordinal number must be between 1 and Ordinal_Number. SQLSTATE=42000
  • View View_Name has not been defined in catalog Catalog_Name. SQLSTATE=42S02
  • Column Column_Name has not been defined. SQLSTATE=42S22
  • View name conflicts with a predefined view definition
  • Out of memory
  • SELECT * only allowed on views
  • Content_Search_Condition OR NOT Content_Boolean_Term not allowed
  • Cannot convert Data_Type_1 to type Data_Type_2
  • Value is out of range for type Data_Type
  • Specification of Relative_Interval must be negative
  • Column_Name is not a column in the view definition
  • Property name conflicts with a predefined property definition
  • Weight value must be between 0.0 and 1.0
  • Error in matches string
  • Property name cannot be set because it is already being used in a VIEW. SQLSTATE=42000
  • View View_Name already exists in catalog Catalog_Name and cannot be redefined. SQLSTATE=42S01
  • Invalid catalog name Catalog_Name. SQLSTATE=42000