SQL Server linked Server question

Dear All, I am trying to execute some SQL, using CAPI.EXEC against a database, this works fine, the problem is tha the table I need to update is a Linked database to this one, when I try and run the SQL I get the following error :'Error: Error executing an Sql statement.\n ----> Error stack\n ----> 1) E675151875:DbLib Message Handler.: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.\n ----> 2) E675151876:DbLib Error Handler DB Error.:General SQL Server error: Check messages from the SQL Server.\n ----> 3) E675086352:Could not execute cursor.:\n ----> 4) E675086344:Error executing an Sql statement.:'Any ideas on how to resolve this ?

Find more posts tagged with

Comments

Jonny_Coombes

Message from Jonny Coombes via eLinkMessage from <> via eLink

eLink

Hi Greg,

As suggested by the error, you need to set the ANSI NULLs and ANSIWARNINGS options in the SQL client (and maybe within the actual linked databaseoptions).

Try that and then see how you get on.

Cheers

JonnyCoombes Bsc (Hons)
Principal Solutions Architect
Open Text Corporation

Mobile: +44 (0) 7748 986 937

Phone:+44 (0) 1494 679700

YIM: ot_jcoombes

The market leader in providing
Enterprise Content Management solutions.
www.opentext.com

This e-mail is protected by domestic and international copyrightlaws and treaties and is the property of Open Text Corporation, it may containconfidential and/or trade secret information of the Open Text Corporationand/or its subsidiaries (OTC), and may be subject to legal privilege in favorof OTC. This e-mail may only be lawfully received, accessed, displayed on acomputer screen, printed, copied, and/or used by the specific addressee(s)named above (“Authorized Recipient”) for the purpose for which it was sent byOTC. All other rights and licenses to this e-mail are fully reserved to OTC. Ifyou are not an Authorized Recipient, you are required to immediately deletethis e-mail in its entirety without printing, copying, using, and/orre-transmitting this e-mail, either in whole or in part. The transmission ofthis e-mail by OTC is not to be construed as a waiver by OTC and/or theindividual sending this e-mail on behalf of OTC of any of their respectiverights or privileges at law or otherwise, howsoever arising.

From: eLink Discussion: Development Discussion[mailto:development@elinkkc.opentext.com]
Sent: 07 December 2006 15:39
To: eLink Recipient
Subject: SQL Server linked Server question

SQL Server linked Server question

Posted by ggriffiths (Griffiths, Greg) on 12/07/2006 10:37 AM

Dear All,
I am trying to execute some SQL, using CAPI.EXEC against a database, this works fine, the problem is tha the table I need to update is a Linked database to this one, when I try and run the SQL I get the following error :

'Error: Error executing an Sql statement.\n
----> Error stack\n
----> 1) E675151875:DbLib Message Handler.: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.\n
----> 2) E675151876:DbLib Error Handler DB Error.:General SQL Server error: Check messages from the SQL Server.\n
----> 3) E675086352:Could not execute cursor.:\n
----> 4) E675086344:Error executing an Sql statement.:'

Any ideas on how to resolve this ?

[To reply to this thread, use your normal E-mail reply function.]
Discussion:	Development Discussion
Livelink Server:	Knowledge Center

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.development@elinkkc.opentext.com.