Heterogeneous Queries, Linked servers, Crystal
Posted on 2014-09-11
I have written a stored procedure Crystal report. The stored proc has a select..... with an inner join to a linked server table (not a view). I create the SP with the setting of ANSI_NULLS and ANSI_WARNINGS ON as most of the threads here say to do. The SP runs great in SSMS (Management studio). But when I go to run it in Crystal, I get the familair "Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection....."
I have gone to the server I am linking to, and set the instance > properties > connections, and checked ansi warnings and ansi nulls. still get the error.
This is all running under SQL Server 2012 (Express) 64 bit.