Bug #61777 [Com]: Cannot bind parameters with pdo_odbc and SQL Server Native Client 11.0

Edit report at https://bugs.php.net/bug.php?id=61777&edit=1 ID: 61777 Comment by: omar dot piani at gmail dot com Reported by: frozen at frozen-solid dot net Summary: Cannot bind parameters with pdo_odbc and SQL Server Native Client 11.0 Status: No Feedback Type: Bug Package: PDO ODBC Operating System: Ubuntu 12.04 PHP Version: 5.3.10 Block user comment: N Private report: N New Comment: I have same problem, binding booleans as true and false, works well using 0 and 1. Regards Previous Comments: ------------------------------------------------------------------------ [2015-02-02 15:54:02] frozen at frozen-solid dot net Problem still occurs in PHP 5.4.36 on Debian ------------------------------------------------------------------------ [2014-12-30 10:41:49] php-bugs at lists dot php dot net No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Re-Opened". Thank you. ------------------------------------------------------------------------ [2014-04-20 23:57:38] stas@php.net Please try using this snapshot: http://snaps.php.net/php-trunk-latest.tar.gz For Windows: http://windows.php.net/snapshots/ Fix for bug #50444 checked in, please see if it also fixes this issue. ------------------------------------------------------------------------ [2014-03-17 13:08:49] donald dot sipe at gmail dot com Are there plans to address this issue in an upcoming php release? This is a serious issue for those of us that would like to use the native MS SQL Server driver since that is the best "Enterprise" solution for connecting to SQL Server on Linux. ------------------------------------------------------------------------ [2013-04-04 20:36:40] me at andrewkehrig dot com I can verify this bug still occurs on php 5.3.19 and php 5.4.6 as well. php 5.3.19 running on Windows experiences a slightly different version of this problem when talking to SQL Server via ODBC: bound parameters work, as long as you're not comparing them directly to date datatype columns (date, timestamp, etc) - if you are, you have to cast them manually from varchar to date, or if you're using a stored procedure with input parameters you have to set any date input parameters to varchar and allow the server to infer the datatype conversion when comparing the input parameter(a varchar holding a date, timestamp, etc) to an actual date,timestamp,etc column. ------------------------------------------------------------------------ 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 https://bugs.php.net/bug.php?id=61777 -- Edit this bug report at https://bugs.php.net/bug.php?id=61777&edit=1