Try switching on all errors and outputting the info from 'mssql_get_last_message()' Rob. -----Original Message----- From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Ankit Mathur Sent: 09 June 2008 09:42 To: php-objects@xxxxxxxxxxxxxxx Subject: RE: SQL Query using Linked Server MSSQL Hi Robert, My linked server is working perfectly fine. When I use the similar query in Query Analyzer I do get the desired resultset. Issue is using the query and displaying results with PHP. Any ideas/suggestions for use with Php? Ankit Mathur To: php-objects@xxxxxxxxxxxxxxxxxxx: ratkinson@xxxxxxxxxxxxxxxxx: Mon, 9 Jun 2008 09:02:46 +0100Subject: RE: SQL Query using Linked Server MSSQL Try these 2 threads :-http://blogs.microsoft.co.il/blogs/natkin178/archive/2008/02/04/sql-select- on-several-different-tables-that-are-in-different-databases-and-on-different- servers-that-are-not-in-the-same-subnet-mask.aspx http://groups.google.com/group/comp.databases.ms-sqlserver/browse_frm/thread/ 3400597e12e9adbc/ae792582b71f2eb8?lnk=gst&q=select+from+multiple+databases#Ro b.-----Original Message-----From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] OnBehalf Of Ankit MathurSent: 09 June 2008 08:53To: in-phpug@xxxxxxxxxxxxxxx; phpexperts@xxxxxxxxxxxxxxx;php-objects@xxxxxxxxxxxxxxxxxxxxxx: [php-objects] SQL Query using Linked Server MSSQLHi All,We has major DB revamp and as a result of it some of my tables have beenshifted to another DB.Now I have to use a Linked Server from the DB I earlier used to fecth data.The syntax I'm using is Select * From [1.1.1.1.].MyDB.dbo.MyTableNow I'm neither getting a result nor an error.Can someone help me on this?Any workarounds ? Any functions that can help me get what is stopping thedata to come by?ThanksAnkit Mathur__________________________________________________________2000 Placements last year. Are You next ? Find outhttp://ss1.richmedia.in/recurl.asp?pid=499[Non-text portions of this message have been removed]------------------------------------Are you looking for a PHP job? Join the PHP Professionals directory Now!http://www.phpclasses.org/professionals/Yahoo! Groups Links************************************************************************ ***********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******************************************************************** *************** _________________________________________________________________ Watch hottest Bollywood videos, clips, movie tailors, star interviews, songs and more on MSN videos. http://video.msn.com/?mkt=en-in [Non-text portions of this message have been removed] ------------------------------------ Are you looking for a PHP job? Join the PHP Professionals directory Now! http://www.phpclasses.org/professionals/Yahoo! Groups Links
