|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2016-02-09 08:56 UTC] zucchetto dot christopher at gmail dot com
Description:
------------
I use PDO with dblib (Freetds / Sybase) : when I try to execute a procedure that doesn't exists on the server (or something else that return an error) with PDO, I have not the correct error returned by errorInfo. However, with previous versions of PHP like 5.2.4 it's worked correctly.
Test script:
---------------
$pdo = new PDO("dblib:host=MY_SERVER", "MY_LOGIN", "MY_PWD");
$st = $pdo->prepare("EXEC A_UNKNOW_PROCEDURE");
$good = $st->execute();
if (!$good) {
$error = $st->errorInfo();
var_dump($error);
}
Expected result:
----------------
The error returned by the Sybase server like : Stored procedure 'A_UNKNOW_PROCEDURE' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output)
Actual result:
--------------
General SQL Server error: Check messages from the SQL Server [2812] (severity 16)
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Tue Oct 28 10:00:01 2025 UTC |
freetds 0.95, with sqlserver actual result: array(5) { [0] => string(5) "HY000" [1] => int(20018) [2] => string(84) "Could not find stored procedure 'A_UNKNOW_PROCEDURE'. [20018] (severity 16) [(null)]" [3] => int(-1) [4] => int(16) }