As of now the work around I followed is of executing 5 seperate queries. 1 each for SET ANSI_NULLS ON and OFF 1 each for SET ANSI_WARNINGS ON and OFF and my query for that page.Things seem to be working as of now. Hopefully we'll be able to find a better solution for this problem. Ankit Mathur To: php-objects@xxxxxxxxxxxxxxxxxxx: ratkinson@xxxxxxxxxxxxxxxxx: Mon, 9 Jun 2008 12:30:09 +0100Subject: RE: SQL Query using Linked Server MSSQL >From what I can find, it looks like you need to set these when connecting tothe MS-SQL server, but PHP doesn't appear to allow for it - perhaps someonecan 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 SQLstatement 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+require+the+ANSI_NULLS+and+ANSI_WARNINGS#Rob.-----Original Message-----From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] OnBehalf Of Ankit MathurSent: 09 June 2008 12:17To: php-objects@xxxxxxxxxxxxxxxxxxxxxx: RE: SQL Query using Linked Server MSSQLWell 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 beset for the connection. This ensures consistent query semantics. Enable theseoptions 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 8400http://www.randomhouse.co.ukhttp://www.booksattransworld.co.uk http://www.kidsatrandomhouse.co.ukGeneric email address - enquiries@xxxxxxxxxxxxxxxxxxxxx & Registered Office:THE RANDOM HOUSE GROUP LIMITED20 VAUXHALL BRIDGE ROADLONDONSW1V 2SARandom House Group Ltd is registered in the United Kingdom with company No. 00954009, VAT number 102838980*********************************************************************************** _________________________________________________________________ Timely update on all current affairs, sports, events and all thats in News here on MSN videos. http://video.msn.com/?mkt=en-in [Non-text portions of this message have been removed]
