ID: 32278
Comment by: ups dot jer at gmail 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:
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.
Previous Comments:
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
[2008-07-01 21:04:27] steven_crombie at yahoo dot com
Web Server:
php 5.2.5
Windows 2003 Server Standard SP1
IIS 6.0
SQL Server:
SQL Server 2005
Windows 2003 Server Standard SP2
Management Studio 9.00.3042.00
I have not been able to get a result set when using php to query the MS
SQL Server when the query references a linked server.
I have also tried putting the query in a database view and querying the
view instead of directly to the tables. Still no results.
I have also tried putting my query in a stored procedure and calling
the stored procedure. Still no results returned.
All three methods (direct query, view, and stored procedure) produce
good results when using Management Studio or the sqlcmd utility.
A fix for this long-standing problem would be most appreciated.
------------------------------------------------------------------------
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
