[firebird-support] Re: cannot connect to localhost with Firebird 2.5 64-bit on CentOS 6.2

2012-02-17 Thread hrefofficemanager
Helen, Thank you for the extra details. I did end up doing a complete reinstall and there was no longer any issue with gsec. It is all working now. Recap: CentOS 6.2 did not need anything extra in the /etc/hosts file as it turns out, at least not with the package choices that I made. My "prob

[firebird-support] Pigging error message

2012-02-17 Thread Lester Caine
I've go to move a server tomorrow, so I've dropped the database to a backup machine but I'm getting an error when I open one of the applications :( Network Error = -104 ... clear it and the program opens, but it's designed to start automatically each morning :( Both machine have 2.1.4 on, I've c

Re: [firebird-support] RPM error, installing on 64-bit Linux

2012-02-17 Thread Helen Borrie
At 09:10 AM 18/02/2012, hrefofficemanager wrote: >FYI: > >Installing onto 64-bit hardware, CentOS 6.2, from > >http://sourceforge.net/projects/firebird/files/firebird-linux-amd64/2.5.1-Release/FirebirdSS-2.5.1.26351-0.amd64.rpm/download > >gives this error (Firefox browser -> RPM manager alert) :

Re: [firebird-support] Re: cannot connect to localhost with Firebird 2.5 64-bit on CentOS 6.2

2012-02-17 Thread Helen Borrie
At 09:03 AM 18/02/2012, hrefofficemanager wrote: >Thanks Philippe! > >> /sbin/service firebird-superserver start > >WORKS to start the server. My next problems is that gsec does not like me. >"Your username and password are not defined" -- yet I am using SYSDBA with the >default password. > >Wh

[firebird-support] RPM error, installing on 64-bit Linux

2012-02-17 Thread hrefofficemanager
FYI: Installing onto 64-bit hardware, CentOS 6.2, from http://sourceforge.net/projects/firebird/files/firebird-linux-amd64/2.5.1-Release/FirebirdSS-2.5.1.26351-0.amd64.rpm/download gives this error (Firefox browser -> RPM manager alert) : Package /tmp/Firebird... has incompatible architecture

[firebird-support] setting a generator inside a SP

2012-02-17 Thread Sergio H. Gonzalez
Hello! In the FB guide reads: "Setting a generator directly to a certain value (“Update”) PSQL GEN_ID(, - GEN_ID(, 0 ) ); Warning This is more of a dirty little trick to do what you normally cannot and should not do in SPs and triggers: /setting/ gener

[firebird-support] Re: cannot connect to localhost with Firebird 2.5 64-bit on CentOS 6.2

2012-02-17 Thread hrefofficemanager
Thanks Philippe! > /sbin/service firebird-superserver start WORKS to start the server. My next problems is that gsec does not like me. "Your username and password are not defined" -- yet I am using SYSDBA with the default password. When I run this from / as root, whereis security2 , no fil

[firebird-support] Force query plan to filter before join

2012-02-17 Thread Alec Swan
Hello, I need help optimizing the query shown below. PROJECT-related tables contain 12 rows each while COPY-related tables contain 14K rows each. Moreover, PROJECT."ASSIGNMENT_STATUS" != 'UNASSIGNED' filters out all but 10 joined rows. My question is how do I change the plan to force PROJECT."AS

[firebird-support] Re: cannot connect to localhost with Firebird 2.5 64-bit on CentOS 6.2

2012-02-17 Thread hrefofficemanager
I saw a note elsewhere about /etc/hosts so I did check it. It has several mentions of localhost but whether it is accurate - I am not sure. My computer domain (during initial installation of CentOS) was fire12.x.com. The /etc/hosts file has this: 127.0.0.1 localhost localhost.localdomain l

Re: [firebird-support] Re: Inserting CR/LF to a string using ISQL

2012-02-17 Thread Steve Wiser
On Fri, Feb 17, 2012 at 6:49 AM, patrick_marten wrote: > ** > > > Hello, > > ist there an alternative for this? > > > In a script you can use this: > > > > insert into foo (test) values ('Hello > > world'); > > The reason is: I'm generating my "insert into"-lines in Excel. Once one of > the cells

[firebird-support] Re: Inserting CR/LF to a string using ISQL

2012-02-17 Thread patrick_marten
Hello, ist there an alternative for this? > In a script you can use this: > > insert into foo (test) values ('Hello > world'); The reason is: I'm generating my "insert into"-lines in Excel. Once one of the cells contains a linebreak, the copied value from Excel has an " at the beginning and a

[firebird-support] Re: cannot connect to localhost with Firebird 2.5 64-bit on CentOS 6.2

2012-02-17 Thread philippe makowski
hrefofficemanager [2012-02-16 21:00] : > Hi, This is regarding a new clean install of CentOS 6.2, 64-bit. > > As root, I ran these 2 commands, without errors: > > rpm -Uvh > http://download.fedora.redhat.com/pub/epel/6/i386/epel-release-6-5.noarch.rpm > > yum install firebird firebird-superserver