[Bug 349205] Re: PHP 5.2.6 cannot read result set from MSSQL stored procedure with tdsodbc 0.82-3

[dominique desforges]

thanks you for your suggest  and post bless

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to freetds in Ubuntu.
https://bugs.launchpad.net/bugs/349205

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

Status in “freetds” package in Ubuntu:
  New

Bug 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.  No Joy.
  Eventually I downgraded FreeTDS back to version 0.63-3.2ubuntu1.
  Everything works fine in that version.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/freetds/+bug/349205/+subscriptions