Hetorgeneous error when trying to add view to new report
Posted on 2004-09-29
I'm trying to write a new Crystal report that involves a SQL view for the data source. Reports created prevously are ADO (for what that's worth). When I go thru Report Expert and try and select the database view I'm getting a
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.
I can add a table, but not any of the views. But there are previously written reports that use other views.
(Sorry, I'm forced to teach myself much of this stuff, so I'm pretty clueless ;-) )