Hi All,
I chased my tail on this for a while, so I wanted to post an FYI. I'm not a PHP person, so this may be better known in the PHP world.
When I attempted to query a MSSQL server, using the: Stimulsoft.StiOptions.WebServer.url = "stimulsoft/handler.php";, and a stored procedure, the stored procedure call would not return my data.
The same call worked in SS management studio, but not through php / pdo_sqlsrv & sqlsrv.
The issue I found was that any stored procedure that had temporary tables, would not return my final query call.
The fix is to include:
SET NOCOUNT ON at the beginning of the sp
and
SET NOCOUNT OFF a the end of the sp
This makes sense as NOCOUNT will stop the server from sending the DONEINPROC message for each step of the sp.
I hope this helps someone.
g
FYI SET NOCOUNT ON/OFF for PHP MSSQL with temp tables
-
- Posts: 1
- Joined: Tue Jan 24, 2023 7:25 pm
-
- Posts: 6366
- Joined: Tue Mar 20, 2018 5:34 am
Re: FYI SET NOCOUNT ON/OFF for PHP MSSQL with temp tables
Hello,
Thank you for the information.
Thank you for the information.