Re: [firebird-support] Proper way to configure Firebird startup on FreeBSD 10

2014-09-12 Thread marcus mar...@antiphasis.net [firebird-support]
stevef...@yahoo.com [firebird-support] wrote: I've successfully installed Firebird on FreeBSD 10 but can't seem to find documentation on the proper way to configure it to run at system startup. Somewhere on the www, I found that you should add the following line to/etc/rc.conf:

Re: [firebird-support] Proper way to configure Firebird startup on FreeBSD 10

2014-09-12 Thread map...@gmail.com [firebird-support]
database access is not restricted to a dir but it can be configured to be done so with DatabaseAccess http://www.firebirdsql.org/manual/qsg2-config.html#qsg2-config-security http://www.firebirdsql.org/manual/qsg2-config.html#qsg2-config-security also firebird runs under firebird user

[firebird-support] Re: Proper way to configure Firebird startup on FreeBSD 10

2014-09-12 Thread stevef...@yahoo.com [firebird-support]
Maybe I should re-phrase my original question: Is there any recommended documentation somewhere about the secure recommended way to start Firebird service and all configuration after installation?

Re: [firebird-support] Configuring Firebird for high transaction through put

2014-09-12 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Russel, Good starting point could be our optimized configuration files: http://ib-aid.com/en/optimized-firebird-configuration/ Regards, Alexey Kovyazin IBSurgeon What type of access (read vs. write mix) are you expecting? Mainly write What mix of small vs. large queries are you expecting?

[firebird-support] Re: Configuring Firebird for high transaction throughput

2014-09-12 Thread Aage Frank Johansen aagjo...@online.no [firebird-support]
How many simultaneous connections are you expecting? that's the big question we are looking at a range of 1400 - 13000 orders per hour This does not look like much of a challenge - but I don't know the nature of your orders processing! Checking your SQL could be a good thing - I'm thinking

[firebird-support] Ran successful install on Mac, but nothing is installed.

2014-09-12 Thread a...@melvin.com [firebird-support]
Please help. This is my first time downloading Firebird. I downloaded from http://www.firebirdsql.org/en/firebird-2-5/#MacOSX and the version I got was FirebirdSS-2.5.3-26778-x86_64.pkg.zip Twice I have run the installer, and each time the installation was successful, yet nothing called

[firebird-support] SQL Error -104

2014-09-12 Thread Johannes Grimm johannes.g...@gmail.com [firebird-support]
Hi folks, i just don't get it what the heck i'm doing wrong. I would like to have something like that: select ba.artno from mov_invoices mi, bas_articles ba where mi.invdate between '2014-05-01 00:00:00' and '2014-08-01 00:00:00' and case when (ba.artno like '90__') then '9000' when (ba.artno

[firebird-support] Unhandled exception at 0x777B03B8 (kernel32.dll) in fsql.exe: 0xC0000005: Access violation writing location 0x00030FFC

2014-09-12 Thread mwaqassha...@hotmail.com [firebird-support]
Dear All, Facing this issue when fsql.exe is runing, Please help to resolve this issue. Unhandled exception at 0x777B03B8 (kernel32.dll) in fsql.exe: 0xC005: Access violation writing location 0x00030FFC. [8/26/2014 6:00:45 PM] Rehman Khaleel: 6.1.7601.17932

RE: [firebird-support] SQL Error -104

2014-09-12 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
i just don't get it what the heck i'm doing wrong. I would like to have something like that: select ba.artno from mov_invoices mi, bas_articles ba where mi.invdate between '2014-05-01 00:00:00' and '2014-08-01 00:00:00' and case when (ba.artno like '90__') then '9000' when (ba.artno