Re: [firebird-support] Re: Scaling up Firebird-2.5.2.26539_0_x64.exe

> > Firebird can handle more than 10 concurent users here is an example with > a production system http://www.firebirdnews.org/?p=6797 > > __,_._,_ There are not 10 concurrent users, are 10 end users using 2500 pooled connections, then there are 2500 concurrent users máximum., that

Re: [firebird-support] Database corruption with FB 1.5 on Linux... Please help

Try install fb 2.5 and do a "select * from " for all your tables. At the end copy the fdb back to your linux server. Em 08/02/2013 16:36, "vladman992000" escreveu: [Non-text portions of this message have been removed]

Re: [firebird-support] Database corruption with FB 1.5 on Linux... Please help

Try install fb 2.5 and do a "select * from " for all your tables. At the end copy the fdb back to your linux server. Em 08/02/2013 16:36, "vladman992000" escreveu: > ** > > > We have a Firebird 1.5 Super Server database on Linux running that decided > last week to stop successfully completing a b

Re: [firebird-support] For loop or while loop inside of a stored procedure?

Perfect, thanks - Original Message - From: Scott Morgan To: firebird-support@yahoogroups.com Sent: Friday, February 08, 2013 11:20 AM Subject: {Disarmed} Re: [firebird-support] For loop or while loop inside of a stored procedure? On 08/02/13 16:54, SoftTech wrote:

[firebird-support] Database corruption with FB 1.5 on Linux... Please help

We have a Firebird 1.5 Super Server database on Linux running that decided last week to stop successfully completing a backup with GBAK. After running for about an hour, it fails with the following error: gbak: ERROR: database file appears corrupt () gbak: ERROR: wrong page type gbak: ERROR:

[firebird-support] Re: Script with 'Drop' in it

Any harm in doing a Delete from RDB$FUNCTIONS where RDB$FUNCTION_NAME = 'LOWER'; I hate touching system tables Todd --- In firebird-support@yahoogroups.com, "camalot_todd" wrote: > > > > --- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote: > > > > > --- In firebird-suppo

[firebird-support] Re: Script with 'Drop' in it

--- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote: > > > --- In firebird-support@yahoogroups.com, "camalot_todd" wrote: > >> > >> > >> > >> --- In firebird-support@yahoogroups.com, "Leyne, Sean" wrote: > >>> > >>> > > I would like to add a script that does a "DROP EXTERNAL

[firebird-support] Re: For loop or while loop inside of a stored procedure?

Hi, Loop dates within a range: create or alter procedure SP_DATES ( INICIO date, FINAL date) returns ( FECHA date) as begin /* Procedure Text */ Fecha = inicio; while (Fecha < final) do begin Fecha = Fecha + 1; suspend; end end Regards. -Christian- [Non-text po

Re: [firebird-support] For loop or while loop inside of a stored procedure?

On 08/02/13 16:54, SoftTech wrote: > I have a stored procedure where I pass in a begin and end date. > > Is there way to process each date within a for or while loop so that I can > return a record for each date regardless if I find any data to report on for > that date? > > Any tips on how to code

Re: [firebird-support] Re: Script with 'Drop' in it

> --- In firebird-support@yahoogroups.com, "camalot_todd" wrote: >> >> >> >> --- In firebird-support@yahoogroups.com, "Leyne, Sean" wrote: >>> >>> > I would like to add a script that does a "DROP EXTERNAL FUNCTION SQRT". > > The problem I have is that some of the databases that will r

[firebird-support] Re: Script with 'Drop' in it

--- In firebird-support@yahoogroups.com, "camalot_todd" wrote: > > > > --- In firebird-support@yahoogroups.com, "Leyne, Sean" wrote: > > > > > > > > I would like to add a script that does a "DROP EXTERNAL FUNCTION SQRT". > > > > > > > > The problem I have is that some of the databases that w

Re: [firebird-support] Re: Scaling up Firebird-2.5.2.26539_0_x64.exe

> --- In firebird-support@yahoogroups.com, "red_october2009" wrote: >> >> I came across this document: >> >> http://www.firebirdsql.org/file/documentation/papers_presentations/html/paper-fbent-impacting.html >> >> It seems to be talking about a much older version of FB than is available >> now.

[firebird-support] For loop or while loop inside of a stored procedure?

Greetings All,, Using Firebird 1.5 I have a stored procedure where I pass in a begin and end date. Is there way to process each date within a for or while loop so that I can return a record for each date regardless if I find any data to report on for that date? Any tips on how to code this wo

[firebird-support] Re: Script with 'Drop' in it

--- In firebird-support@yahoogroups.com, "Leyne, Sean" wrote: > > > > > I would like to add a script that does a "DROP EXTERNAL FUNCTION SQRT". > > > > > > The problem I have is that some of the databases that will run this script > > already have the UDF dropped and so the script errors. > > >

[firebird-support] Re: Scaling up Firebird-2.5.2.26539_0_x64.exe

--- In firebird-support@yahoogroups.com, "red_october2009" wrote: > > I came across this document: > > http://www.firebirdsql.org/file/documentation/papers_presentations/html/paper-fbent-impacting.html > > It seems to be talking about a much older version of FB than is available > now. Even

RE: [firebird-support] Script with 'Drop' in it

> > I would like to add a script that does a "DROP EXTERNAL FUNCTION SQRT". > > > > The problem I have is that some of the databases that will run this script > already have the UDF dropped and so the script errors. > > > > Is there a way to run statements like DROP INDEX, DROP EXTERNAL > FUNCTION

Re: [firebird-support] Re: Firebird speed degrades during the day

Em 7/2/2013 08:53, Carlos H. Cantu escreveu: > Are you sure you ran gstat when things were already slow (as asked by > Thomas)? > > Carlos > Firebird Performance in Detail - http://videos.firebirddevelopersday.com > www.firebirdnews.org - www.FireBase.com.br > > > Besides that... We should not for

Re: [firebird-support] Re: Firebird 2.5 windows authentication and roles grants question?

> Found the problem. > The role must granted to the domain group. > Example: > > GRANT to "\" Mind the 31 character limitation. -- With regards, Thomas Steinmaurer http://www.upscene.com/

[firebird-support] Re: Firebird 2.5 windows authentication and roles grants question?

Found the problem. The role must granted to the domain group. Example: GRANT to "\" Works perfect.

[firebird-support] special question Win 7 fb odbc

Perhaps I can get a little help in this group, the odbc devel does not insert my question at the time. I get no response. Hello, I use firebird 2.1 32 Bit cs on Server 2008. On my pc (Win 7 64 Bit) I have installed Access 2010 32 Bit and the Firebird ODBC Driver 32 Bit. The Firebird Tab

AW: [firebird-support] Re: restore a firebird 2.1 gbk in firebird 2.5

Hello, >Hi, >View the following: > http://paulbeachsblog.blogspot.com.ar/2011/07/firebird-v21-error-value-excee ds-range.html >Regards. >-Christian- Thank you! [Non-text portions of this message

AW: AW: [firebird-support] restore a firebird 2.1 gbk in firebird 2.5

Hi > I am the first and only firbird user with this issue? What can I do? > > > > Thanks. I think no. ;-) In example: http://sourceforge.net/mailarchive/message.php?msg_id=23092682 Gabor Thank you!