CSCux28865 - CUIC sets ansi warnings and nulls off, breaks linked server queries

[sherrerogon]

For a custom report, we are trying to get some information from a table that is placed in a Database in a server different from AW. We have tried to use a linked server and a view and we both methods we get an error.

The error is:   Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.

com.microsoft.sqlserver.jdbc.SQLServerException: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection

We have enabled those options at the beginning of the report, but the error is still there (image1.png)

Has someone find a solution?

[boyd.lynn]

This seems to work.

https://community.cisco.com/t5/collaboration-blogs/setting-ansi-nulls-and-warnings-to-on/ba-p/3631533

[Gerry O'Rourke]

I found setting these at the database level and restarting SQL server fixed this issue for me.

In SQL Studio - right Click the database -> Properties - > Options 

Set ANSI_NULLS and ANSI_WARNING to True.

Gerry