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

2013-02-08 Thread Olaf Kluge
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!

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

2013-02-08 Thread Olaf Kluge
Hello, Hi, View the following: http://paulbeachsblog.blogspot.com.ar/2011/07/firebird-v21-error-value-exce eds-range.html 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 have

[firebird-support] special question Win 7 fb odbc

2013-02-08 Thread Olaf Kluge
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

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

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

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

2013-02-08 Thread Alexandre Benson Smith
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 forget he

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

2013-02-08 Thread Leyne, Sean
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, etc. in a

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

2013-02-08 Thread mariuz
--- 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 back in

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

2013-02-08 Thread camalot_todd
--- 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. Is there a way

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

2013-02-08 Thread SoftTech
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

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

2013-02-08 Thread camalot_todd
--- 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 run this script

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

2013-02-08 Thread Scott Morgan
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 this

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

2013-02-08 Thread Christian Mereles
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

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

2013-02-08 Thread camalot_todd
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-support] Database corruption with FB 1.5 on Linux... Please help

2013-02-08 Thread vladman992000
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:

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

2013-02-08 Thread SoftTech
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:

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

2013-02-08 Thread fabianoaspro
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 my...@techsol.org escreveu: ** We have a Firebird 1.5 Super Server database on Linux running that decided last week to stop successfully

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

2013-02-08 Thread fabianoaspro
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 my...@techsol.org escreveu: [Non-text portions of this message have been removed]

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

2013-02-08 Thread Jesus Garcia
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 are