Re: [firebird-support] Firebird 2.1 - Shutting down

2015-05-12 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On Mon, 11 May 2015 21:37:15 +, Dan Smith dsm...@ksbdental.com [firebird-support] firebird-support@yahoogroups.com wrote: We are a provider of a commercial software package that runs on the firebird database, this afternoon we have been deluged with offices calling that their database is

Re: [firebird-support] Connecting to Superserver on CentOS 6

2015-05-12 Thread marcus mar...@antiphasis.net [firebird-support]
Hej, On 12.05.2015 00:45, 'David E. Wheeler' da...@justatheory.com [firebird-support] wrote: Firebirders, I have been using the firebird-classic RPM for testing Sqitch, connecting like so: isql-fb -u sysdba -p masterkey This worked well, but now I’d like to use superserver,

Re: [firebird-support] Connecting to Superserver on CentOS 6

2015-05-12 Thread 'David E. Wheeler' da...@justatheory.com [firebird-support]
On May 12, 2015, at 2:22 AM, Helen Borrie hele...@iinet.net.au [firebird-support] firebird-support@yahoogroups.com wrote: Means either the Superserver isn't running or you have an incompatible version of isql. I'm guessing the first. Supposing the password is 'whatever', get into

Re: [firebird-support] Connecting to Superserver on CentOS 6

2015-05-12 Thread 'David E. Wheeler' da...@justatheory.com [firebird-support]
On May 12, 2015, at 2:22 AM, Helen Borrie hele...@iinet.net.au [firebird-support] firebird-support@yahoogroups.com wrote: Use the fbmgr executable to manage superserver. But there is no default 'masterkey' password for SYSDBA. You should find a temporary password in a text file named

Re: [firebird-support] Connecting to Superserver on CentOS 6

2015-05-12 Thread 'David E. Wheeler' da...@justatheory.com [firebird-support]
On May 12, 2015, at 10:14 AM, David E. Wheeler da...@justatheory.com wrote: Will try another box and some of the other stuff Helen suggested. Okay, worked fine on another box. I’m assuming that the first box has some classic cruft leftover somewhere or something that’s horking the superserver

Re: [firebird-support] losing connection with server on a local PC

2015-05-12 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
El 12/5/2015, a las 20:56, shg_siste...@yahoo.com.ar [firebird-support] firebird-support@yahoogroups.com escribió: Hello! I have a Delphi app with Firebird. Everything in a single PC which is accesed via Remote Desktop by 5 or 6 users. It worked fine for much years. But since

[firebird-support] losing connection with server on a local PC

2015-05-12 Thread shg_siste...@yahoo.com.ar [firebird-support]
Hello! I have a Delphi app with Firebird. Everything in a single PC which is accesed via Remote Desktop by 5 or 6 users. It worked fine for much years. But since yesterday, My app reports an error of conection lost. I'm used to see this error when working on a local network and some PC lost

[firebird-support] RE: Firebird 2.1 - Shutting down

2015-05-12 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Dan, We are a provider of a commercial software package that runs on the firebird database,  this afternoon we have been deluged with offices calling that their database is down.  In every case we are finding firebird 2.1 shut down.  Restarting it seems to only last for a bit. Is anyone

Re: [firebird-support] Connecting to Superserver on CentOS 6

2015-05-12 Thread 'David E. Wheeler' da...@justatheory.com [firebird-support]
On May 12, 2015, at 3:04 AM, Philippe Makowski pmakow...@ibphoenix.fr [firebird-support] firebird-support@yahoogroups.com wrote: fresh install in Centos6 from epel : # yum install firebird-superserver # service firebird-superserver start $ isql-fb -user SYSDBA -password masterkey Use

[firebird-support] Re: Connecting to Superserver on CentOS 6

2015-05-12 Thread Philippe Makowski pmakow...@ibphoenix.fr [firebird-support]
Le 12/05/15 00:45, 'David E. Wheeler' da...@justatheory.com [firebird-support] a écrit : What do I need to tweak to get it so that I can connect and create a database? The hosts file includes “localhost” as a name for 127.0.0.1, for what that’s worth, so I doubt it’s a host name issue.

[firebird-support] Firebird default charset

2015-05-12 Thread Resul Demirok resul.demi...@gmail.com [firebird-support]
Hi, I have a fdb firebird database and i want to change database default charset for turkish charset. e.g. When i use sql order by varchar field, this field is ordered but turkish charsets were at the end of sorted records every time. How can i solve this issue? Please help me:/ Thanks.

Re: [firebird-support] Re: Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)

2015-05-12 Thread sboyd...@gmail.com [firebird-support]
Assuming OPS_ONBOARD_TIME, OPS_DELIVERED_TIME and OPS_APPT_LOW are all DATE type,does this solve that problem? COALESCE(OPS_ONBOARD_TIME, OPS_DELIVERED_TIME, OPS_APPT_LOW, CURRENT_DATE) Since they are all TIMESTAMPS, that didn't fix the problem but CURRENT_TIMESTAMP did. Thanks.