PHP 5.2.6 cannot read result set from MSSQL stored procedure with tdsodbc 0.82-3

[Wes Grant]

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.

[dominique desforges (dominiquedesforges69)]

thanks you for your suggest and post bless