Description:
------------
OS: Debian Linux 4.0
PHP: 5.2.0-8+etch9 and 5.2.25
unixODBC: 2.2.11-13
ODBC Driver: IBM iSeries Access for Linux V5R4, Version 1.4

Second execution of a prepared select statement with bind parameters fails.

Through trial and error, I found that it'll actually work if I:
#1) don't define any variables between odbc_execute()
#2) cycle through all of the results

 OR
comment out the SQLFreeStmt(.. SQL_RESET_PARAMS) in ext/odbc/php_odbc.c line #1102, ie:

--cut--
        if (result->numparams > 0) {
               /* SQLFreeStmt(result->stmt, SQL_RESET_PARAMS); */
                for(i = 0; i < result->numparams; i++) {
                        if (params[i].fp != -1)
                                close(params[i].fp);
                }
                efree(params);
        }
--cut--

I'm not a C guy.  I figure the above is present for a reason, I've just noticed that removing it fixes this problem for this version of of the IBM ODBC/DB2 driver.

Reproduce code:
---------------
$conn = odbc_connect('host','user','pass');
$stmt='select cn from ldapusr where cn like ?';
$res =odbc_prepare($conn, $stmt);

if (! odbc_execute($res, array('%ken%'))) {
    trigger_error(odbc_error($conn) . ': ' . odbc_errormsg($conn), E_USER_ERROR);
}
if (odbc_fetch_row($res)) {
    print odbc_result($res, 1) . "\n";
}

//$anything='asdf';     // add this and it stops working
while (odbc_fetch_row($res)) {}       // remove this and it stops working


print 'Second:\n';
if (! odbc_execute($res, array('%steve%'))) {
    trigger_error(odbc_error($conn) . ': ' . odbc_errormsg($conn), E_USER_ERROR);
}
if (odbc_fetch_row($res)) {
    print odbc_result($res, 1) . "\n";
}


Expected result:
----------------
records

Actual result:
--------------
07001: [unixODBC][IBM][iSeries Access ODBC Driver]Wrong number of parameters.