On my LAN the same code is OK. This issue just happens
on my VPN clients and just with Date/DateTime fields.

This is the code:

public void Buscar(){
                        
                        DbCommand comandoBuscar =
Phoenix.Conexion.CreateCommand();
                        
                        comandoBuscar.CommandText="SELECT "+this.Campos+"
FROM "+this.Tabla+" WHERE "+
                                "UPPER("+this.CampoBusqueda+") LIKE
upper('%"+txtNombre.Text+"%') "+this.Condicion;

                        
                        DbDataAdapter adaptadorDeDatos = 
FabricaConexion.CrearAdaptador();
                        adaptadorDeDatos.SelectCommand=comandoBuscar;
                        
                        tablaDeDatos = new DataTable();
                        adaptadorDeDatos.Fill(tablaDeDatos); //here is the
issue on VPN
                        dataGrid1.DataSource = tablaDeDatos;
                        
                        if (tablaDeDatos.Rows.Count<=0)
                                btnSeleccionar.Enabled=false;
                        else
                                btnSeleccionar.Enabled=true;
                }

Thanks in advance.

Regards.

--- Ivan Arabadjiev <[EMAIL PROTECTED]> escribió:

> Have you tried executing the same query on your LAN
> or Localhost? Is there a
> chance that your regional settings do not match the
> ones of the firebird
> server? If they do - try synchronizing them. I`ve
> had issues of client
> unable to parse date/time strings not matching its
> own regional settings ...
> 
> 
> 
>
-------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio
> 2008.
>
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
>
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 


_______________________________
I'm free, I use GNU/Linux.
Close your Windows, Open your mind.


      
____________________________________________________________________________________
¡Capacidad ilimitada de almacenamiento en tu correo!
No te preocupes más por el espacio de tu cuenta con Correo Yahoo!:              
        
http://correo.yahoo.com.mx/

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to