Re: [firebird-support] firebird 1.5 installation in linux

2019-02-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 13-2-2019 07:57, wang...@yahoo.com [firebird-support] wrote: > firebird 1.5 linux built is for 32 bits, is it possible to install it in > a 64 bit linux? Thanks. Firebird 1.5 has been unsupported for almost 10 years now. It is really time to start upgrading. I think the only way is to try it

Re: {Disarmed} [firebird-support] firebird 1.5 installation in linux

2019-02-13 Thread Elmar Haneke el...@haneke.de [firebird-support]
> firebird 1.5 linux built is for 32 bits, is it possible to install it > in a 64 bit linux? Thanks. As long as your 64Bit Linux does have support for 32Bit and the required 32Bit runtimes are installed it should be possible to install.

[firebird-support] firebird 1.5 installation in linux

2019-02-12 Thread wang...@yahoo.com [firebird-support]
Hi, firebird 1.5 linux built is for 32 bits, is it possible to install it in a 64 bit linux? Thanks.

Re: [firebird-support] Firebird 1.5 on Windows 10 32

2018-01-15 Thread fo...@darsys.com.ar [firebird-support]
Hi I renamed the setup and worked. I use it to migrate some customers databases that are still in 1.5 version. Thank you Manuel

Re: [firebird-support] Firebird 1.5 on Windows 10 32

2018-01-12 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 12-1-2018 19:10, fo...@darsys.com.ar [firebird-support] wrote: > I can't install FB 1.5 on my Windows 10 32b > > I get "this app can't run on this PC" > > In "more information" opens MS page that says "your app does not work on > your PC. > > In adition, I had it installed it. I think it was

Re: [firebird-support] Firebird 1.5 on Windows 10 32

2018-01-12 Thread DougC d...@moosemail.net [firebird-support]
Why, oh why, do you even have a copy of FB 1.5 to use? It has been long left behind by the Firebird project. Unsupported for years. Try a more recent version! On Fri, 12 Jan 2018 13:10:28 -0500 fo...@darsys.com.ar [firebird-support] wrote

[firebird-support] Firebird 1.5 on Windows 10 32

2018-01-12 Thread fo...@darsys.com.ar [firebird-support]
Hi I can't install FB 1.5 on my Windows 10 32b I get "this app can't run on this PC" In "more information" opens MS page that says "your app does not work on your PC. In adition, I had it installed it. I think it was unistalled by Windows Update. Antivirus Eset TIA Manuel

RE: [firebird-support] Firebird 1.5 with Yii - table not found

2016-08-09 Thread jonatan.laurit...@yahoo.dk [firebird-support]
Both databases have dialect 1 and that means that case in table names and quotation is irrelevant. I managed to call generator from 1.5 database but tables are not accessible still from the Active record infrastrcture: $list = Yii::$app->db->createCommand('select gen_id(contract_ino, 1) from

RE: [firebird-support] Firebird 1.5 with Yii - table not found

2016-08-09 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Jonatan, > I can connect to both Firebird 1.5 and 2.1 databases, but only from 2.1 > database I can read table data. When I am trying to read data from Firebird > 1.5 database I receive message: > > Invalid Configuration > The table does not exist: BANKS > 0 > yii\base\InvalidConfigException > >

[firebird-support] Firebird 1.5 with Yii - table not found

2016-08-09 Thread jonatan.laurit...@yahoo.dk [firebird-support]
I am trying to use Firebird 1.5 database with Yii with Yii-Firebird extension yii2-firebird | Extension | Yii PHP Framework http://www.yiiframework.com/extension/yii2-firebird/ http://www.yiiframework.com/extension/yii2-firebird/ yii2-firebird | Extension | Yii PHP Framework http://www.

Re: [firebird-support] firebird 1.5

2016-05-17 Thread robert rottermann rob...@redcor.ch [firebird-support]
Thanks Helen for this thorough explanation. I decided to keep the db running on windows and try to access it from linux. robert On 10.05.2016 22:25, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > Hello robert, > > Wednesday, May 11, 2016, 3:47:19 AM, you wrote: > >> I got a databa

Re: [firebird-support] firebird 1.5

2016-05-10 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Hello robert, Wednesday, May 11, 2016, 3:47:19 AM, you wrote: > I got a database that was created with a firebird 1.5 on windows. > Now I installed Firebird-1.5.2.4731-Win32.exe an a windows 7 and on a > windows 10 machine. > I copied also the following files into the UDF folder: > MD5 > Udf

[firebird-support] firebird 1.5

2016-05-10 Thread robert rottermann rob...@redcor.ch [firebird-support]
Hi friends in firebird, I got a database that was created with a firebird 1.5 on windows. Now I installed Firebird-1.5.2.4731-Win32.exe an a windows 7 and on a windows 10 machine. I copied also the following files into the UDF folder: MD5 UdfArithmetic UdfArithmetic.dll UdfControl UdfC

RE: [firebird-support] Firebird 1.5 - CURRENT_TIMESTAMP difference

2014-12-12 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
>Hey guys, > >I'm having some issues with a time difference on a server - the software we've >built around Firebird checks that the client and server do not have a >time different of more than 30 minutes otherwise certain functionality is >disabled. > >Now the server time is fine, but when query

[firebird-support] Firebird 1.5 - CURRENT_TIMESTAMP difference

2014-12-11 Thread emad...@yahoo.com.au [firebird-support]
Hey guys, I'm having some issues with a time difference on a server - the software we've built around Firebird checks that the client and server do not have a time different of more than 30 minutes otherwise certain functionality is disabled. Now the server time is fine, but when querying

RE: RES: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-06-01 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
on it. After making sure everything is working right with 2.5.2, we then upgrade our first server. -HalimTo: firebird-support@yahoogroups.com From: firebird-support@yahoogroups.com Date: Fri, 30 May 2014 13:51:17 -0600 Subject: Re: RES: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware

Re: RES: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-30 Thread Josh Hartmann jhartm...@computekdental.com [firebird-support]
-feira, 29 de maio de 2014 21:42 > Para: firebird-support@yahoogroups.com > Assunto: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad > performance > > > > > > We recently upgraded our database server from Win server 2003 to Win 2008 > server. We upgra

RES: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-30 Thread 'Fabiano - Desenvolvimento SCI' fabi...@sci10.com.br [firebird-support]
” (without cache) instead of a “Database serve”. De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Enviada em: quinta-feira, 29 de maio de 2014 21:42 Para: firebird-support@yahoogroups.com Assunto: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad

RE: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-30 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
Will do.Thank you.-Halim To: firebird-support@yahoogroups.com From: firebird-support@yahoogroups.com Date: Fri, 30 May 2014 14:31:07 +0400 Subject: Re: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

Re: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-30 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
you, -Halim To: firebird-support@yahoogroups.com From: firebird-support@yahoogroups.com Date: Fri, 30 May 2014 08:06:04 +0400 Subject: Re: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

RE: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-30 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
Date: Fri, 30 May 2014 08:06:04 +0400 Subject: Re: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance Halim, It is out of context. Recent 2.5.2 has no such problem. Where did you read it? Regards, Alexey Kovyazin

Re: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-29 Thread 'Alexey Kovyazin (ak)' a...@ib-aid.com [firebird-support]
Halim, It is out of context. Recent 2.5.2 has no such problem. Where did you read it? Regards, Alexey Kovyazin IBSurgeon 30.05.2014 4:41 пользователь "halim1...@hotmail.com [firebird-support]" < firebird-support@yahoogroups.com> написал: > > > We recently upgraded our database server from Win se

[firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-29 Thread halim1...@hotmail.com [firebird-support]
We recently upgraded our database server from Win server 2003 to Win 2008 server. We upgraded hardware as well. The new hardware (IBM x3550 M4) is way more advanced than the old one. 4 times the RAM and CPU speed. We ran some tests on the new hardware(a few select/update queries), the performa

RE: RE: [firebird-support] Firebird 1.5 Order by Query

2013-11-22 Thread vendee928
Yes, thanks, that's made the performance between the two queries comparable again. ---In firebird-support@yahoogroups.com, wrote: >I have a simple query: > >SELECT first 1 ITEM_DATE FROM HISTORY >WHERE ITEM_ID = 'ITEM_ID_123456' >and ITEM_TYPE = 'TYPE1' >AND ITEM_STATUS > 200 and

RE: [firebird-support] Firebird 1.5 Order by Query

2013-11-22 Thread Svein Erling Tysvær
>I have a simple query: > >SELECT first 1 ITEM_DATE FROM HISTORY >WHERE ITEM_ID = 'ITEM_ID_123456' >and ITEM_TYPE = 'TYPE1' >AND ITEM_STATUS > 200 and ITEM_STATUS <> 310 >ORDER BY ITEM_DATE ASC > >Which runs in about 1.5 seconds. If I remove the Order by it's less than >100ms. There are only three

[firebird-support] Firebird 1.5 Order by Query

2013-11-22 Thread vendee928
Hi, I have a simple query: SELECT first 1 ITEM_DATE FROM HISTORY WHERE ITEM_ID = 'ITEM_ID_123456' and ITEM_TYPE = 'TYPE1' AND ITEM_STATUS > 200 and ITEM_STATUS <> 310 ORDER BY ITEM_DATE ASC Which runs in about 1.5 seconds. If I remove the Order by it's less than 100ms. There are o

[firebird-support] Firebird 1.5 and 2.5 co-exists in OS X?

2013-07-23 Thread wang960
Hi, I have a FB 1.5 classic running in OS X, now I need to install FB 2.5 into the same machine, is this possible? and how to do that ? Thanks, wang

[firebird-support] firebird 1.5 (linux) rougue process

2013-03-05 Thread crizz11
We have a process in FB 1.5 (Linux) that has a very long runtime 2952 firebird 20 0 9900 7412 2848 S5 0.2 287:21.12 fb_inet_server 287:21.12 is the CPU time. Is there any tool that will tell us what the process is stuck on? e.g what sql query it is currently executing. regards Chris

[firebird-support] firebird 1.5 (linux) rougue process

2013-03-05 Thread crizz11
Hi there, we have a process running on our firebird 1.5 server that has quite a long run time 2952 firebird 20 0 9900 7412 2848 S 11 0.2 285:28.97 fb_inet_server 285:28.97 is the CPU time for this process. Is there a tool for looking into what this process is stuck on? regards Chris

Re: [firebird-support] Firebird 1.5: How to tell the size of one table inside Fdb file?

2012-02-14 Thread Ann Harrison
Sean, > > I am 99.9% sure that the limit applies to data not counting blobs. > The limit on table size does not include the actual size of blobs, but considers each blob to be eight bytes long. Advance yourself to 100% confident. Cheers, Ann

RE: [firebird-support] Firebird 1.5: How to tell the size of one table inside Fdb file?

2012-02-14 Thread Leyne, Sean
> I have a Firebird 1.5 database that has grown up to 26.6 Gb. Most of the data > is stored in one single table that holds a memo field. I'm worried about the > size of this table, because as far as I know the maximun table size for > version 1.5 is about 36 Gb and I guess I'll soon get close to t

Re: [firebird-support] Firebird 1.5: How to tell the size of one table inside Fdb file?

2012-02-14 Thread Alexandre Benson Smith
Em 14/2/2012 22:46, Nando escreveu: > Hi to all, > > I have a Firebird 1.5 database that has grown up to 26.6 Gb. Most of the data > is stored in one single table that holds a memo field. I'm worried about the > size of this table, because as far as I know the maximun table size for > version 1.

[firebird-support] Firebird 1.5: How to tell the size of one table inside Fdb file?

2012-02-14 Thread Nando
Hi to all, I have a Firebird 1.5 database that has grown up to 26.6 Gb. Most of the data is stored in one single table that holds a memo field. I'm worried about the size of this table, because as far as I know the maximun table size for version 1.5 is about 36 Gb and I guess I'll soon get clos

Re: [firebird-support] Firebird 1.5 client and 2.5 database

2012-01-18 Thread Ann Harrison
On Wed, Jan 18, 2012 at 10:34 AM, Elmar Haneke wrote: > > > Problems may arise since the Server is not fully compatible - SQL > working on 1.5 might fail on 2.5. > That's an application problem, not related to the fbclient version. The project goal, generally, is to allow gradual upgrades rather

Re: [firebird-support] Firebird 1.5 client and 2.5 database

2012-01-18 Thread Elmar Haneke
> This is probably a stupid question but here goes anyway. I have a Delphi > application that is currently running on FB1.5. I need to move to FB2.5. Is > it necessary to update the FB client on the client PC's from 1.5 to 2.5 or is > the 1.5 client compatible with the 2.5 database? > I have fo

Re: [firebird-support] Firebird 1.5 client and 2.5 database

2012-01-18 Thread Thomas Steinmaurer
> This is probably a stupid question but here goes anyway. I have a Delphi > application that is currently running on FB1.5. I need to move to FB2.5. Is > it necessary to update the FB client on the client PC's from 1.5 to 2.5 or is > the 1.5 client compatible with the 2.5 database? > I have fou

[firebird-support] Firebird 1.5 client and 2.5 database

2012-01-18 Thread paultugwell
This is probably a stupid question but here goes anyway. I have a Delphi application that is currently running on FB1.5. I need to move to FB2.5. Is it necessary to update the FB client on the client PC's from 1.5 to 2.5 or is the 1.5 client compatible with the 2.5 database? I have found that PC

Re: [firebird-support] Firebird 1.5 - Stored procedure error 335544348

2011-12-23 Thread Milan Babuskov
Nando wrote: >> ISC ERROR CODE:335544348 >> no current record for fetch operation. Use LEFT JOIN: http://www.firebirdfaq.org/faq144 -- Milan Babuskov == The easiest way to import XML, CSV and textual files into Firebird: http://www.guacosoft.com/xmlwizard ==

Re: [firebird-support] Firebird 1.5 - Stored procedure error 335544348

2011-12-22 Thread Svein Erling Tysvær
>Hi, > >I'm having trouble with this simple stored procedure: > >SET TERM !! ; >CREATE PROCEDURE test_proc (d_date TIMESTAMP) > RETURNS (Result CHAR(50)) >AS BEGIN > Result = CAST(d_date AS CHAR(50)); > SUSPEND; >END !! >SET TERM ; !! > >If I execute this statement it works fine: > >"SELECT a.my

[firebird-support] Firebird 1.5 - Stored procedure error 335544348

2011-12-21 Thread Nando
Hi, I'm having trouble with this simple stored procedure: SET TERM !! ; CREATE PROCEDURE test_proc (d_date TIMESTAMP) RETURNS (Result CHAR(50)) AS BEGIN Result = CAST(d_date AS CHAR(50)); SUSPEND; END !! SET TERM ; !! If I execute this statement it works fine: "SELECT a.my_id, a.some_date