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

Reply via email to