Public bug reported:
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.
** Affects: freetds (Ubuntu)
Importance: Undecided
Status: New
** Description changed:
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.
+ 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.
--
PHP 5.2.6 cannot read result set from MSSQL stored procedure with tdsodbc 0.82-3
https://bugs.launchpad.net/bugs/349205
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
