You’re offline. This is a read only version of the page.
DOC 1 ERROR: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]'UCase' is not a recognized built-in function name.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'AND'.
I was building integrations all days and then made one minor correction to one to use the correct field for the query relationship. As soon as did that I now keep getting the old UCASE message. UseOptimizedFiltering is set to False and there are no special characters in any of the field names. I have tried everything I can think of to get this integration to work. When I run SQL Profiler and look at the SQL statement built to tie the header records to the detail records it is wrong and it fails when I paste into SSMS. So whatever is building the query relationship query is the culprit.
*This post is locked for comments
I have the same question (0)
The fix was applying the latest service pack for IM. UCase is an ORACLE function.
Share
Report
75,852
All responses (
Answers (
