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
> [email protected]
>
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
