FreeTDS Development Group

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

well following the instructions I change my script but that didn't work, so I 
change my freetds.conf, from default of tds version 4.2 to 8.0 and is working 
ok, I mean stored procedures are working, now I'm having a problem with my 
charset, we have in the database words with spanish acents, when I have tds 
4.2 I can see the acents but stored procedures don't work, when I change to 
tds 8.0 stored procedures works but I can't see the spanish acent, I have 
rather a ?, any ideas on how to fix this.
 Best Reagrds
Allan Kim <akim AT freedom.com> wrote: For more debugging information turn on 
FreeTDS logging -- just uncomment 
one line in freetds.conf.

Here are a few possibilities:

1. The OOP model changed after PHP 5.0.4. In particular you can't pass a 
literal value as an argument if the method expects a reference.

See if it helps to rewrite this line:

$dbconn->InParameter($stmt,$centro_costo,'id_area');

as:

$foo = 'id_area';
$dbconn->InParameter($stmt,$centro_costo,$foo);


2. MSSQL returns trivial notices or warnings that get picked up as 
errors. Here's where the FreeTDS debugging logs will help. Sometimes 
wrapping your database calls in a try/catch block will help. There's no 
logical reason why it should work, but it does.

Good luck Aliet.

Aliet Santiesteban Sifontes wrote:
> 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.
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> 

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds



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