Re: [firebird-support] How do you hook up Zeos to FB embedded?

2015-09-29 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 08:53 p.m. 29/09/2015, Mark Patterson mark.aurel...@gmail.com [firebird-support] wrote: >Hi > >I have put all the DLLs in the same directory as the EXE I am producing.I have >copied fbembed.dll to both fbclient.dll and gds32.dll. I have a TZConnection >with protocol = 'firebird-2.5' Â and

Re: [firebird-support] For embedded is it enough to just include fbembed.dll in our own install?

2015-09-29 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 02:51 p.m. 29/09/2015, Mark Patterson mark.aurel...@gmail.com [firebird-support] wrote: >Hi > >We are translating an accounting application from using MySQL to being single >user. We have tried a couple of other embedded database systems, but they have >limitations that multiply the work

Re: [firebird-support] invalid request BLR 623; LTRIM not defined; entrypoint not found.

2015-09-29 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 05:44 p.m. 29/09/2015, s hj senthile...@gmail.com [firebird-support] wrote: >Occasionally (not always) I get the following error when I run some stored >procedures or views (database objects) that use the LTRIM function: >

[firebird-support] How do you hook up Zeos to FB embedded?

2015-09-29 Thread Mark Patterson mark.aurel...@gmail.com [firebird-support]
Hi I have put all the DLLs in the same directory as the EXE I am producing.I have copied fbembed.dll to both fbclient.dll and gds32.dll. I have a TZConnection with protocol = 'firebird-2.5' and when I set Connected := true on it, I get this error message: None of the dynamic libraries can be

Re: [firebird-support] For embedded is it enough to just include fbembed.dll in our own install?

2015-09-29 Thread Mark Patterson mark.aurel...@gmail.com [firebird-support]
Thanks, Helen. I copied all the possible dlls into the same directory as the exe. Now I am getting an error from the Zeos TZConnection component. I posted a question to firebird-support. On 29 September 2015 at 16:48, Helen Borrie hele...@iinet.net.au [firebird-support]

Re: [firebird-support] invalid request BLR 623; LTRIM not defined; entrypoint not found.

2015-09-29 Thread s hj senthile...@gmail.com [firebird-support]
Thanks very much Helen. I appreciate it. To give a background, I use a 32-bit as well as a 64-bit client of Firebird Database. The reason is that I can work with a 32-bit client for the SSDT part of Microsoft SSRS, and the 64-bit client for the Microsoft Report Manager. This whole Firebird

[firebird-support] Error on Gfix

2015-09-29 Thread Jeferson Sisto jsis...@gmail.com [firebird-support]
Hi! I'm using Firebird 2.5.x and the command gfix -v -full returned: Summary of validation errors Number of record level errors : 3 Number of database page errors : 1993 What I have to do in order to fix it, without a backup/restore? I read in "Firebird Documentation" that the command gfix -v

[firebird-support] Re: How do you hook up Zeos to FB embedded?

2015-09-29 Thread Mark Patterson mark.aurel...@gmail.com [firebird-support]
Thanks, Helen. I am asking at the zeos forum as well. I don't want to waste your time, just hoping someone may recognise something obscure to me. Regards Mark On Tuesday, 29 September 2015, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > > > At

[firebird-support] Privileges on monitoring tables

2015-09-29 Thread Stefan Sinne ste...@smartastur.com [firebird-support]
Hello, When connecting to a Firebird 2.5.4 database, a non-SYSDBA user can make a select on MON$ATTACHMENTS without any problem. Then SYSDBA grants and revokes some privilege, like grant all on mon$attachments to procedure xyz; commit; revoke all on mon$attachments from procedure xyz; commit;

RE: [firebird-support] Error on Gfix

2015-09-29 Thread 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]
I would have thought that at least steps 1 & 2 would be required, I thought it was the second step that actually ‘fixed’ things. Cheers, Neil Pickles - n...@csy.co.uk From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 29 September 2015 21:50 To:

RE: [firebird-support] Error on Gfix

2015-09-29 Thread 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]
We have a 4 part fix process for fixing database, first two commands are gfix and the final two are gbak. 1. %gfix% -v -ignore -full -user SYSDBA -password masterkey %1 2. %gfix% -mend -ignore -user SYSDBA -password masterkey %1 3. %gbak% -b -g -ig -v -user SYSDBA

Re: [firebird-support] Error on Gfix

2015-09-29 Thread Jeferson Sisto jsis...@gmail.com [firebird-support]
Ok, I know this full procedure about corrupt database. But, when the unique problem about corrupt database is ORPHAN PAGE. In this especific situation, is necessary to execute all the steps, including the backup/restore? Looking my situation, I'm having ONLY orphan page in a database that have

Re: [firebird-support] firebird service terminated unexpectedly

2015-09-29 Thread Eduardo guse...@gmail.com [firebird-support]
Thank you for your answer. May be upgrading will solve the problem but, for what you say, it is not sure that 2.1.7 will be the solution. Anyway, it is strange that the same version in many other similar networks has no problem. Even in the same network it was working without problems many

Re: [firebird-support] Firebird 2.5 Language Reference

2015-09-29 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Thank you very much Germán Greetings. Walter. On Tue, Sep 29, 2015 at 10:10 PM, Germán Balbi bal...@yahoo.com [firebird-support] wrote: > > > Para una mucho mejor traducción usa el traductor de Microsoft > http://www.bing.com/translator/ > > > [image: image]

Re: [firebird-support] Firebird 2.5 Language Reference

2015-09-29 Thread Germán Balbi bal...@yahoo.com [firebird-support]
Para una mucho mejor traducción usa el traductor de Microsoft http://www.bing.com/translator/ |   | |   | |   |   |   |   |   | | TraductorDescargar aplicaciones Translator Translator Apps Skype Translator | | | | Ver en www.bing.com | Vista previa por Yahoo | | | |   | El

Re: [firebird-support] Error on Gfix

2015-09-29 Thread liviusliv...@poczta.onet.pl [firebird-support]
Hi, look into Firebird.log – there are more infos about corruptions recognized by gfix regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Tuesday, September 29, 2015 2:53 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Error on Gfix Hi!

Re: [firebird-support] Error on Gfix

2015-09-29 Thread Jeferson Sisto jsis...@gmail.com [firebird-support]
Hi! I know Firebird.log and its informations... also, this information are very helpful. However, always when we detect a corrupt database, our team run a backup/restore. It can be a problem when a database has 20, 30 GB. I read that gfix can fix orphan pages, and our corrupt is about orphan