Skip to Content
0
Former Member
Jul 04, 2012 at 03:18 AM

Crystal 2011 - Database Connector Error:42000 SQL Server SET options has incorrect settings

1118 Views

My SQL stored procedure that I call from Crystal does have xml in it (ie it uses OPENXML etc). But it is able to work OK with Crystal Reports 7, but not with SAP Crystal Reports 2011.

I have not been able to verify my Crystal 2011 report, but I can with Crystal 7.

Error is Database Connector Error:'42000:[Microsoft ][SQL Native Client][SQL Server] INSERT failed because the following SET options have incorrect settings:CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING'. Verifty that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. [Database Vendor code:1934 ]'

I do understand the ANSI settings are set in layers -

- Database – used for both (on SQL Server Management studio – looks correct)

- ODBC connection to database (SQL Native Client) – looks correct

- Crystal 7 or Crystal 2011 - ?

- The actual Crystal Report – can’t find settings in the report itself.

- SQL - made change to stored procedure to set these -

SET ANSI_NULLS ON

SET ANSI_PADDING ON

SET ANSI_WARNINGS ON

SET CONCAT_NULL_YIELDS_NULL ON

SET ANSI_NULL_DFLT_ON ON

SET QUOTED_IDENTIFIER ON

SET ARITHABORT ON

Can anyone help?