ID: 32278 Comment by: webster_jack at hotmail dot com Reported By: raulionescu at gmail dot com Status: No Feedback Bug Type: MSSQL related Operating System: WinXP Pro PHP Version: 5.0.4 New Comment:
Hi Has this bug been fixed? Previous Comments: ------------------------------------------------------------------------ [2007-12-12 19:33:37] kenneth dot kaye at bankofamerica dot com This bug still exists as of PHP 5.1.2. I run PHP(cli) 5.1.2 on Windows 2003 Server, and attempting to execute a stored procedure within PHP that calls a linked server yields the following error: PHP Warning: mssql_execute(): message: 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. (severit y 16) in c:\logs\btest.php on line 46 PHP Warning: mssql_execute(): stored procedure execution failed in c:\logs\btest.php on line 4 6 PHP Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in c:\logs\btest.php on line 55 I have ANSI_NULLS and ANSI_WARNINGS set within the stored procedure itself. Any advice or a fix? ------------------------------------------------------------------------ [2006-09-15 13:58:20] redshifteric at gmail dot com Bug reproduced on Win2k Server MSSQL 2000 SP3 PHP 5.1.2 I tried using the normal syntax to access table on the linked server. I mean using linkedservername.databasename.dbo.tablename or directoty the local tablename but without success. If i specify the full linked server path, i get the following error: Could not find server 'KCONT81' in sysservers. Execute sp_addlinkedserver to add the server to sysservers But if i execute the same query trough isqlw.exe (query analyzer) it works fine. Best regards, Red ------------------------------------------------------------------------ [2005-06-14 01:00:03] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2005-06-07 00:17:31] [EMAIL PROTECTED] Try putting 'error_reporting(E_ALL);' as first line in your script and see if you get any warnings/notices.. ------------------------------------------------------------------------ [2005-06-06 11:00:52] raulionescu at gmail dot com I've tried and no changes. Even more, when I tried to execute stored procedures who takes very long time to run (~10-15min), the result is none and my opinion is that seems like a time-out beeing reached because the same stored procedure runs with no problems from SQL querry anliser. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/32278 -- Edit this bug report at http://bugs.php.net/?id=32278&edit=1