Hi Paul, Yes, FlameRobin works fine on any query.
Regards. --- Mercea Paul <[EMAIL PROTECTED]> escribió: > 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 > > > 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 > > > > ------------------------------------------------------------------------- > 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
