General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The data type text cannot be used as an operand to The UNION, INTERSECT or EXCEPT operators because it is not comparable. Native error:5335 - when using a search window in Raiser's Edge

Error: Error loading grid: General ODBC Error: [Microsoft][ODBC SQL Server 
Driver][SQL Server]The data type text cannot be used as an operand to 
The UNION, INTERSECT or EXCEPT operators because it is not comparable.
Native error:5335
[Microsoft][ODBC SQL Server Driver]The cursor was not 
declared. 
Native Error:16945
Search Window, using Query/Classic Search View in conjunction with "Use Enhanced Search" causes the error above. This can occur if your Query contains the "Annotation" output.

If using a Query:
1. Open Query being used
2. Output tab
3. Remove the Field: Annotation

OR

Uncheck "Use Enhanced Search" in the Search Window (Note: This option only appears as selectable if you have entered information in a search box, such as, Last Name, First Name, etc. In your Search Window)

Steps to Duplicate

Steps to Duplicate:
1. Records > Constituent
2. Open Constituent
3. Search using Query: <Include a Query>
4. Last Name: <Enter any name>
5. Click Options
6. Choose "Show Classic Search View When Using Enhanced Search"
7. Checkmark "Use Enhanced Search"
8. Click "Find Now"
9. Receive Error:
Error loading grid: General ODBC Error: [Microsoft][ODBC SQL Server 
Driver][SQL Server]The data type text cannot be used as an operand to 
The UNION, INTERSECT or EXCEPT operators because it is not comparable.
Native error:5335
[Microsoft][ODBC SQL Server Driver]The cursor was not 
declared. 
Native Error:16945

Was this article helpful?