[firebird-support] IMPORTANT MESSGAGE: This group is moving

2020-05-01 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Hello Firebird-support members, The firebird-support list is moving to Google Groups. The new location is https://groups.google.com/d/forum/firebird-support Unfortunately we cannot migrate the current Yahoo! subscribers, and you will need to resubscribe yourself, in one of two ways: (1) If you

Re: [firebird-support] run firebird engine without fbguard

2019-07-12 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Yassir Kozha wrote: > We currently use fbguard to run the firebird engine as recommended in the > docs of firebird. > Systemd service unit: > ‘ExecStart=/usr/sbin/fbguard -daemon -onetime’ > > The problem with this approach is that when killing the firebird > engine process ‘SIGKILL’, the

Re: [firebird-support] Connecting to database on remote server

2019-07-08 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Tony Christiansen wrote: > I am running an app on my PC that connects to a database on my firebird > server FIREBIRDSERVER > The path is \\FIREBIRDSERVER\E:\DB.FDB > If my pc has an E: drive (ie I plug in a usb) I can connect to the database. > If my pc has no E: drive then I cannot connect to

Re: [firebird-support] FB 2.5.8 - Next transaction value growing too much.

2019-07-01 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Hernando Duque wrote: > I've working around tuning up a database speed and found that gstat > -h shows valuable information about transactions. Also that gfix > -sweep removes garbage from the database. Sweep (whether automatic or manual) removes garbage that is able to be removed. > I

Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different

2019-06-23 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Anto wrote: > Thanks for your info. > Downloaded ver 1.52, now it worked. > On Process tab of RAMMap, firebird.exe took 2,183,484K. > On File details tab, database file took 2,603,168K. > Don't know, if this means file cached work or not. > If file cached worked, then there is something else

Re: ** NOT ** Re: [firebird-support] Firebird upgrade advise

2019-06-05 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Rita Liotta wrote: > Hi, Helen: > > Can you name some of these tools? I'm just floundering try to find one. > Only you can know what you need, according to your expertise with databases and SQL and your comprehension of the drivers needed to use a particular toolset. As a rule, the free

** NOT ** Re: [firebird-support] Firebird upgrade advise

2019-06-05 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Rita Liotta wrote: > I don't know what happened, but this isn't my question. What happened is that you replied to a thread that was on a different subject - it is called "hijacking". You should have started a new topic. > What I asked was > if there was any way I can access and sort the

Re: [firebird-support] Re: Issue with large table in FB 1.5 and 2.5

2019-05-29 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
> Also one further question Do later versions of Firebird (ie. 3 > or 4) have any performance increase for cooperative garbage > collection at all? No. GC requires reading the version chain of all records in the contexts of their transactions. It takes as long as it takes. > Would I

Re: [firebird-support] Issue with large table in FB 1.5 and 2.5

2019-05-29 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
[..] > My code that loads the data commits the transactions after the > DELETE statement, and then at each 5,000 rows loaded. I have > checked this by watching the load and using IBExpert to count > records, so I can confirm that the commits are happening. > After the loading has completed, what

Re: [firebird-support] Re: Engine12 32 64 bit question

2019-05-19 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
a...@liberov.net wrote: > Thanks a lot! > When everything else fails read the manual. > I put xnet:// in front of the local path and it connects now. > The IBDAC has a property to specify library location. I did put the > path to 32 bit fbclient, but until I put xnet:// in front of the > path

Re: [firebird-support] Engine12 32 64 bit question

2019-05-17 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
a...@liberov.net wrote: > I'm developing a 32 bit application running on 64 bit Windows with 64 bit > Firebird 3 server. > I use 32 bit library to connect to Firebird > C:\Program Files\Firebird\Firebird_3_0\WOW64\fbclient.dll > I'm getting the engine12 Win32 error 193. This means some

Re: [firebird-support] Firebird 4 and RDB$ERROR

2019-05-15 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Steve Bailey wrote: > I am using Firebird 4.0 Beta 1. So - off-topic in Firebird Support. But, anyway... > The release notes describe a new system function RDB$ERROR: > "The function RDB$ERROR() takes a PSQL error context as input and > returns the specific context of the active > exception.

Re: [firebird-support] unsubscribe

2019-05-07 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Antonio BIANCA wrote: > What means this email? > I've not understood!!! > Il 07/05/2019 08:26, Brian Dunstan brian.duns...@health.telstra.com > [firebird-support] ha scritto: >> Don't worry - it doesn't mean anything. Someone (wrongly) thought this was the right way to remove himself from

Re: [firebird-support] insert data two databases different

2019-05-06 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Joel Moo wrote: > Hi guys, i have a situation, I work with a database name database1.fdb, > and so, i do maintanance over this databases weekly. > I backup this database before maintenance, but the maintenance failed, > so the .fdb file in which the maintenance failed will rename it to >

Re: [firebird-support] Help with Firebird date ranges.

2019-05-02 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Hello traceya...@yahoo.com.au, Thursday, May 2, 2019, 11:15:24 PM, you wrote: > I am a complete noobie in regards Firebird, :-( and I have 1 system with that > has Firebird installed. > I need to be able to report on the last 7 days data from the date a report is > run. > Currently i have

Re: [firebird-support] Issues restoring a Firebird Database

2019-04-28 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Scott Marcellus wrote: > I have been trying to use different restores for the > past couple of weeks for one specific database and it seems I am > able to restore the database with data in the database restores > tables but it does not have any procedures or views or anything like > that. I am

Re: [firebird-support] re: Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

2019-04-26 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Chris LeFebvre wrote: > One thing, my application is 64bit and I do have the 64bit > fbclient.dll in the Debug / application so can you connect to an > embedded database at design time by checking the Connected property > of the TFDConnection component? I remember reading somewhere that > during

Re: [firebird-support] Start/Stopping service

2019-04-18 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Hello m_brahi...@yahoo.fr, > Thank you for answer, > Yes the service is present in Local Services and the file > executable file in the area is > C:\Firebird\Firebird_3_0\firebird.exe -s firebird3 > anyway I have no problem with managing service to access my > application but I don't know if

Re: [firebird-support] Start/Stopping service

2019-04-18 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Hello m_brahi...@yahoo.fr, > I am using Firebird-3.0.3.32900_0_Win32.exe on XP when I try to > start service in installed FB folder with > C:\Firebird\Firebird_3_0>instsvc sta or instsvc sto > I get that message > "Error occured during OpenService" > The specified service doens't exists as