ID: 32278
Comment by: ericsolan at yahoo 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:
try adding this right before you call your mssql_query
$result = mssql_query("SET ANSI_NULLS ON") or
die(mssql_get_last_message());
$result = mssql_query("SET ANSI_WARNINGS ON") or
die(mssql_get_last_message());
Previous Comments:
------------------------------------------------------------------------
[2009-03-24 20:53:42] ups dot jer at gmail dot com
To provide further info, I just verified that I cannot do this
directly, nor can I call a stored proc which in turn hits the linked
server.
------------------------------------------------------------------------
[2009-03-24 20:51:56] ups dot jer at gmail dot com
Reproduced on PHP Version 5.2.4-2ubuntu5.5
------------------------------------------------------------------------
[2009-03-16 14:44:40] mcollard at hotmail dot com
Seconded, this issue is ongoing and problematic.
------------------------------------------------------------------------
[2009-02-19 12:56:46] aromal at gmail dot com
any update on this?
somebody there to give us a reply?
------------------------------------------------------------------------
[2008-07-02 16:35:05] steven_crombie at yahoo dot com
Additional comment to the post above...
To test that there was nothing amiss with the setup, code, or database
server, I changed the query to pull data from a database local to the
SQL Server (not linked database). I got the expected result set.
------------------------------------------------------------------------
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
