From: podunk dot vn at gmail dot com Operating system: windows xp sp2/IIS/ASAPI PHP version: 5.2.0 PHP Bug Type: PDO related Bug description: pdo_odbc Extention throws HY090 with doing binary sqlbindcol
Description: ------------ When selecting a varbinary(MAX) field from a microsoft sql 2005 database, using the Microsoft ODBC Driver Manager for SQL, and binding the result to a PHP variable, the Driver Manager fails with the following error: array ( 0 => 'HY090', 1 => 0, 2 => '[Microsoft][ODBC Driver Manager] Invalid string or buffer length (SQLBindCol[0] at ext\\pdo_odbc\\odbc_stmt.c:430)', 3 => 'HY090', ) More information on HY090 can be found at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlbindcol.asp Just a guess: the BufferLength isn't being set in odbc_stmt.c somewhere. Reproduce code: --------------- $stmt = $db->prepare("select data from cms_files where fid=11"); $db->execute($stmt); $db->bindColumn($stmt, 1, $lob, PDO::PARAM_LOB); $db->fetch_bound($stmt); Expected result: ---------------- $lob populated with binary data. Actual result: -------------- Driver Manager throws: array ( 0 => 'HY090', 1 => 0, 2 => '[Microsoft][ODBC Driver Manager] Invalid string or buffer length (SQLBindCol[0] at ext\\pdo_odbc\\odbc_stmt.c:430)', 3 => 'HY090', ) -- Edit bug report at http://bugs.php.net/?id=40289&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=40289&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=40289&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=40289&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=40289&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=40289&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=40289&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=40289&r=needscript Try newer version: http://bugs.php.net/fix.php?id=40289&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=40289&r=support Expected behavior: http://bugs.php.net/fix.php?id=40289&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=40289&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=40289&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=40289&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=40289&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=40289&r=dst IIS Stability: http://bugs.php.net/fix.php?id=40289&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=40289&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=40289&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=40289&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=40289&r=mysqlcfg
