Hi If you use IBExpert,DBWorkbench,FlameRobin,ISQL or another tool can you run without errors the select command on vpn network?
Regards, Paul > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Alex Castillo > Sent: Wednesday, February 06, 2008 4:21 AM > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] FBException using VPN > > 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 ------------------------------------------------------------------------- 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
