[firebird-support] Firebird can't connect to host

2014-11-14 Thread Andromeda andromedar...@gmail.com [firebird-support]
Hello, I'm new in FirebirdSQL. I can't connect into my host address whereas it can connect to localhost successfully. It prompt show errors like this: SQL connect 192.168.1.37:/var/lib/firebird/2.5/data/employee.fdb user 'SYSDBA' password 'masterkey'; Statement failed, SQLSTATE = 08006 Unable

RE: [firebird-support] sum data into single row per day

2014-11-14 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
for select iif(n.code=1,sum(n.amount),0), iif(n.code=2,sum(n.amount),0), iif(n.code=3,sum(n.amount),0), n.sell_date from new_table n where n.sell_date between :fromdate and :uptodate group by n.sell_date,n.code

Re: [firebird-support] Change Write Mode

2014-11-14 Thread Tiziano tmdevelo...@yahoo.com [firebird-support]
I have different software connected to db: 1. Delphi + IB_Object/IBO2. Web/WCF + NHibernate + Firebird ADO.NET3. Winforms + Firebird ADO.NET 4. DB Access (linked to firebird with external table) + ODBC It is possible that a data connection change write mode? Il Giovedì 13 Novembre 2014

Re: [firebird-support] Change Write Mode

2014-11-14 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
I have different software connected to db: 1. Delphi + IB_Object/IBO2. Web/WCF + NHibernate + Firebird ADO.NET3. Winforms + Firebird ADO.NET 4. DB Access (linked to firebird with external table) + ODBC It is possible that a data connection change write mode? Yes. In your IBO application,

[firebird-support] Backup/Restore Required ???

2014-11-14 Thread t...@camalot.ca [firebird-support]
Wondering if a Backup/Restore is requird for moving from 2.5.2 to 2.5.3? I have done it here without any issues so far, but thought I better ask the question. Todd Brasseur Compass Municipal Services Inc.

[firebird-support] Re: Backup/Restore Required ???

2014-11-14 Thread t...@camalot.ca [firebird-support]
Thanks a bunch. Todd

Re: [firebird-support] Backup/Restore Required ???

2014-11-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 14 Nov 2014 08:08:59 -0800, t...@camalot.ca [firebird-support] firebird-support@yahoogroups.com wrote: Wondering if a Backup/Restore is requird for moving from 2.5.2 to 2.5.3? I have done it here without any issues so far, but thought I better ask the question. It isn't technically

Re: [firebird-support] Backup/Restore Required ???

2014-11-14 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Wondering if a Backup/Restore is requird for moving from 2.5.2 to 2.5.3? Usually this is not needed when the ODS version hasn't been changed (between maintenance releases), but there is a special situation when coming from 2.5.1:

Re: [firebird-support] Cross database update

2014-11-14 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Hello Christian, I am having problems regarding an update skript I want to write that fetsches data from table1 in db1 and writes the result into exisiting records in table2 in db2. To mange this task I am using firebird 2.1.5 and a tool called IBExpert with a script extension called

Re: [firebird-support] sum data into single row per day

2014-11-14 Thread Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support]
Thank you Svein, that's what I tried but kept getting: SQL error code = -104. Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause). and yet it now works. I thought it must have been because I was accessing code in the iif(...). I must have

[firebird-support] Firebird on Mac

2014-11-14 Thread 'William, David' david.will...@espn.com [firebird-support]
Hi, I am trying to run Firebird on mac (our standard development platform). I have tried all server packages available on Firebirdsql.org . The installation process runs ok. But whenever I try to start the server, I get this: $ fbguard fbguard: Invalid user (must be firebird, interbase,