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
