I have ran into an error that I cant figure out. We recently moved our data from 2000 to 2005 servers. We use actuate as a reporting platform and run reports from a server off site against our sql2005 servers here. When I changed the data source for a report to test we get an error.
7405: [SQL State] : [DataDirect][ODBC SQL Server Driver][SQL Server]Heterogeneous queries require th
e 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.
We have checked/set ansi_nulls and Ansi_warnings on in every location we can find, Server, sproc, dbase, and odbc connection. I have found a load of helpful info dealing with this issue, but my issue must be different, because the problem still exists. The query does use a linked server. and if we point back to the 2000 server it runs fine. Im hoping someone out there has encountered this issue and can give me some insight into how they got around it. Almost all of our reports cross servers to get to their data.
Thx
7405: [SQL State] : [DataDirect][ODBC SQL Server Driver][SQL Server]Heterogeneous queries require th
e 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.
We have checked/set ansi_nulls and Ansi_warnings on in every location we can find, Server, sproc, dbase, and odbc connection. I have found a load of helpful info dealing with this issue, but my issue must be different, because the problem still exists. The query does use a linked server. and if we point back to the 2000 server it runs fine. Im hoping someone out there has encountered this issue and can give me some insight into how they got around it. Almost all of our reports cross servers to get to their data.
Thx
