2009-03-26 22:02:08 |
Wes Grant |
description |
Upgraded from Ubuntu 8.04 to 8.10. PHP code that worked on 8.04 ceased to work on 8.10:
$db_result = odbc_exec($db_connection, $stored_procedure_sql);
if($db_result){
if (odbc_num_rows($db_result)){ // this would = -1 when I know the it should >1
$i = 0;
do{
while(@$row = odbc_fetch_array($db_result)){
$db_recordset[$i][] = $row;
}
$i++;
} while (odbc_next_result($db_result)); // this doesn't happen. Result set is completely empty.
}
I set the FreeTDS driver to write debugging information to a log file. I could see that the stored procedure ran successfully and 200 results were returned. However, PHP can't seem to read them.
I re-installed php5-odbc, and all of the FreeTDS packages. Eventually I downgraded FreeTDS back to version 0.63-3.2ubuntu1. Everything works fine in that version. |
Upgraded from Ubuntu 8.04 to 8.10. PHP code that worked on 8.04 ceased to work on 8.10:
$db_result = odbc_exec($db_connection, $stored_procedure_sql);
if($db_result){
if (odbc_num_rows($db_result)){ // this would = -1 when I know the it should >1
$i = 0;
do{
while(@$row = odbc_fetch_array($db_result)){
$db_recordset[$i][] = $row;
}
$i++;
} while (odbc_next_result($db_result)); // this doesn't happen. Result set is completely empty.
}
I set the FreeTDS driver to write debugging information to a log file. I could see that the stored procedure ran successfully and 200 results were returned. However, PHP can't seem to read them.
I re-installed php5-odbc, and all of the FreeTDS packages. No Joy. Eventually I downgraded FreeTDS back to version 0.63-3.2ubuntu1. Everything works fine in that version. |
|