>From what I can find, it looks like you need to set these when connecting to the MS-SQL server, but PHP doesn't appear to allow for it - perhaps someone can suggest a workaround. You may be able to resolve the problem by calling a stored procedure instead, where you can set these settings when you create the procedure. Your SQL statement will then use those settings by default :- http://groups.google.com/group/microsoft.public.sqlserver.connect/browse_frm/ thread/b9780787974f07c9/ee22c0220596c628?lnk=st&q=Heterogeneous+queries+requi re+the+ANSI_NULLS+and+ANSI_WARNINGS# Rob. -----Original Message----- From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Ankit Mathur Sent: 09 June 2008 12:17 To: php-objects@xxxxxxxxxxxxxxx Subject: RE: SQL Query using Linked Server MSSQL Well this error was resolved by removing (WITH NOLOCK) But a new message came by. "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. "Ankit *********************************************************************************** Any opinions expressed in email are those of the individual and not necessarily those of the company. This email and any files transmitted with it are confidential and solely for the use of the intended recipient or entity to whom they are addressed. It may contain material protected by attorney-client privilege. If you are not the intended recipient, or a person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited. Random House Group + 44 (0) 20 7840 8400 http://www.randomhouse.co.uk http://www.booksattransworld.co.uk http://www.kidsatrandomhouse.co.uk Generic email address - enquiries@xxxxxxxxxxxxxxxxx Name & Registered Office: THE RANDOM HOUSE GROUP LIMITED 20 VAUXHALL BRIDGE ROAD LONDON SW1V 2SA Random House Group Ltd is registered in the United Kingdom with company No. 00954009, VAT number 102838980 ***********************************************************************************
