FreeTDS Development Group

[Aliet Santiesteban Sifontes <alietss AT yahoo.com>]

Hi people, I'm upgrading a server at school, it had freetds-0.62.4 and 
php-5.0.2, this server was hosting lot's of php applications wich uses stored 
procedures to connect to a sql server 2000 and return recordsets, this setup 
was working great, but we are upgrading to debian to do some tests, we are 
using freetds-0.63 and php-5.0.5, first we hit the bind bug in php code, 
applied the patch, the bind problem was solved but now we are loosing the php 
object and stored procedures are not working, we are using php adodb, 
 a fragment of code:
 ...
       list($dbconn) = swDBGetConn();
 
       // Get Desc Area
 
       $query = 'Get_Area_Desc';
       // this is a stored procedure,  very simple,       
       // just make a select of a table with 
      //one input paramenter of type varchar
 
       $stmt = $dbconn->PrepareSP($query);    
 
       $dbconn->InParameter($stmt,$centro_costo,'id_area'); 
 
       $result = $dbconn->Execute($stmt);
 
       if($dbconn->ErrorNo() != 0) {
 
                 die("Error con la consulta de la descripción del áreas");
 
       }
 
       list($cod_area, $nombre_area) = $result->fields;
 
       $result->Close();
 When executes  $result->Close(); it returns this
 Fatal error:  Call to a member function Close() on a non-object in 
/var/www/test/devel/modules/SW-Finanzas/instance/submayor.php on line 178
 
 In previous setup this same code works ok.
 Any ideas...
 Best Reagards 
 


                
---------------------------------
 Yahoo! Music Unlimited - Access over 1 million songs. Try it free.