Hetorgeneous error when trying to add view to new report

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 ;-) )
Who is Participating?
vidruConnect With a Mentor Commented:
Pretty sure this is a SQL Server issue.  Found this thread with a potential solution:

It points to re-creating the view, setting ANSI_NULLS and ANSI_WARNINGS before the CREATE VIEW statement.

What database?  What version of Crystal?

If it is a SQL Server issue, you might see if those can be set as the default.  I don't recall having to set them for any view or stored procedure I built for use in Crystal.

th1434Author Commented:
Sorry to have flaked out on this -- I was given other projects and didn't even have a chance to even think about the responses.

(I did talk to the programmer (created the database and original Crystal reports) last week and the solution was to use ADO connection -- he's sending me a quick run down later).

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.