[firebird-support] Error opening a database

2019-12-02 Thread Tony Christiansen t...@adegroup.com.au [firebird-support]
We have FB3.0.3 installed on a server with 200 odd users each accessing their own database. A number have reported this error when attempting to open a database today. Internal Firebird consistency check (cannot start garbage collector thread) IProvider::attachDatabase failed when loading

[firebird-support] Re: A recommendation (database migration)

2019-12-02 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] a écrit : > Is this link permanent? if so, and if you agree, I can publish it at > firebirdnews.org > > []s > Carlos > www.firebirdnews.org - www.FireBase.com.br it can be and if there is any other problem I can fix it. -- Norbert

Re: [firebird-support] Re: A recommendation (database migration)

2019-12-02 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
Is this link permanent? if so, and if you agree, I can publish it at firebirdnews.org []s Carlos www.firebirdnews.org - www.FireBase.com.br NSGntefs> 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] a écrit : >> Hi! >> >> If you have a compiled version with the fix, I think a lot of

Re: [firebird-support] A recommendation (database migration)

2019-12-02 Thread Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]
I do know that - just have never tried the cross platform yet but would love to. :) Thanks! Kevin > On Dec 2, 2019, at 11:12 AM, Karol Bieniaszewski liviusliv...@poczta.onet..pl > [firebird-support] wrote: > > > >> That’s part of the issue - I’m a Delphi guy and not sure I could

[firebird-support] Re: A recommendation (database migration)

2019-12-02 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] a écrit : > Hi! > > If you have a compiled version with the fix, I think a lot of people > would enjoy if you can share the executable ;-) done http://tetrasys.fi/data/ibpump.7z -- Norbert Saint Georges http://tetrasys.fi

Re: [firebird-support] A recommendation (database migration)

2019-12-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.12.2019 19:19, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] wrote: > If you have a compiled version with the fix, I think a lot of people > would enjoy if you can share the executable ;-) I'm sorry, I'm not sure if I'm allowed to share it. -- WBR, SD.

ODP: [firebird-support] Re: A recommendation (database migration)

2019-12-02 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
>> That’s part of the issue - I’m a Delphi guy and not sure I could get it >> cross platform. Delphi is crossplatform. It suport Windows, macOS, iOS, Android and now Linux from one codebase. Regards, Karol Bieniaszewski

Re: [firebird-support] A recommendation (database migration)

2019-12-02 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
Hi! If you have a compiled version with the fix, I think a lot of people would enjoy if you can share the executable ;-) Carlos www.firebirdnews.org - www.FireBase.com.br DSsicfs> 02.12.2019 18:28, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] wrote: >> IB DataPump from

Re: [firebird-support] A recommendation (database migration)

2019-12-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.12.2019 18:28, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] wrote: > IB DataPump from Clevercomponents has problems with FB 3, but now it > is open source. It is made in Delphi. If someone interested and with > some free time can fix the problem and even update the application:

Re: [firebird-support] A recommendation (database migration)

2019-12-02 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
IB DataPump from Clevercomponents has problems with FB 3, but now it is open source. It is made in Delphi. If someone interested and with some free time can fix the problem and even update the application: https://github.com/CleverComponents/Interbase-DataPump/ []s Carlos Migration Guide do FB 3

[firebird-support] Re: A recommendation (database migration)

2019-12-02 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] a écrit : > That’s part of the issue - I’m a Delphi guy and not sure I could get it cross > platform. > I use Delphi also but would be more interesting to start on codetyphon (free pascal). we wait for another opinion. --

Re: [firebird-support] Fail to create external table

2019-12-02 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Den 2019-12-02 kl. 16:56, skrev Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]: > 02.12.2019 16:35, Kjell Rilbe kjell.ri...@marknadsinformation.se > [firebird-support] wrote: >> Any ideas? > In short: give up. Just give up. > In long: both client side and server side ANSI code

[firebird-support] Re: A recommendation (database migration)

2019-12-02 Thread blackfalconsoftw...@outlook.com [firebird-support]
Kevin... EMS Sql Manager has a great list of tools for Firebird and Interbase that will provide the very processes you are looking for... https://www.sqlmanager.net https://www.sqlmanager.net Granted these are commercial products but I have been using them for years and have found them

Re: [firebird-support] A recommendation (database migration)

2019-12-02 Thread Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]
That’s part of the issue - I’m a Delphi guy and not sure I could get it cross platform. > On Dec 2, 2019, at 8:51 AM, Norbert Saint Georges n...@tetrasys.eu > [firebird-support] wrote: > > Kevin Stanton kevin.stan...@rdb-solutions.com >

[firebird-support] Re: A recommendation (database migration)

2019-12-02 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] a écrit : > I would be happy to donate time to help in anyway I can. This is an awesome > database and I can’t say enough about FB and the developers. Hello, Your tool would be developed in what language? and for which platform?

Re: [firebird-support] Fail to create external table

2019-12-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.12.2019 16:35, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Any ideas? In short: give up. Just give up. In long: both client side and server side ANSI code pages must support these letter. -- WBR, SD.

[firebird-support] A recommendation (database migration)

2019-12-02 Thread Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]
Greetings! We are in the middle of migrating from FB 1.56 to 3.x. Of course the recommendation is to create a script of the database and run it against FB 3 which we’ve done. We’ve also purchased the Migration Guide to Firebird 3. Now comes the challenge - getting the data over. Some of our

[firebird-support] Fail to create external table

2019-12-02 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Hi, Using Firebird 3.0.4.33054 on WIndows (64 bit), I want to create an external table where the external file name contains Swedish letters. I would think this is a reasonable desire these days. After failing to get the character encoding right in FlameRobin, I thought I'd try isql.exe. So

Re: [firebird-support] What key word specifies a search for an entire word?

2019-12-02 Thread Richard Damon rich...@damon-family.org [firebird-support]
On 12/2/19 5:06 AM, Tjioe Hian Pin thp_p...@yahoo.com [firebird-support] wrote: >   > what about: > > SELECT fstName, fiKeyID FROM Members WHERE ' '||fstName||' ' > containing ' '||@po||' ' > > Cheers, > Tjioe > Again, that is likely prevent use of an index to find the record, and force a table

Re: [firebird-support] What key word specifies a search for an entire word?

2019-12-02 Thread Tjioe Hian Pin thp_p...@yahoo.com [firebird-support]
what about: SELECT fstName, fiKeyID FROM Members WHERE ' '||fstName||' ' containing ' '||@po||' ' Cheers,Tjioe On Saturday, November 30, 2019, 02:20:00 PM GMT+7, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:   On 29-11-2019 22:52, Clyde Eisenbeis cte...@gmail.com