| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 0.2.0 |
| Bug #21147 | function errorInfo uses MSSQLisms | ||
|---|---|---|---|
| Submitted: | 2016-11-08 11:51 UTC | ||
| From: | christian_gfk | Assigned: | |
| Status: | Open | Package: | MDB2_Driver_odbc (version 0.2.0) |
| PHP Version: | Irrelevant | OS: | RHEL 6.6 |
| Roadmaps: | (Not assigned) | ||
[2016-11-08 11:51 UTC] christian_gfk
(Christian Wiese)
Description:
------------
The function to get error information uses a feature specific to Microsoft
SQL Server: "SELECT @@ERROR".
This is not supported on other RDBMS, and leads to every session run
through MDB2_driver_odbc to eventually run into an error because "SELECT
@@ERROR" is not a valid SQL statement for them.
Expected result:
----------------
I don't know if a more generic solution exists (is PHP's odbc_error()
appropriate? odbc_errormsg() is already being used). If one is available, it
should be used instead. Otherwise the implicit "SELECT @@ERROR"
statement should be removed.