[firebird-support] How to convert to one charset to another

2014-05-20 Thread Loris Luise loris.lu...@gmail.com [firebird-support]
Hello, I need your help and suggestions to solve a (maybe uncommon) task. I searched a lot on the web, I had some success using a tool called fbclone but this is definitely not a solution (due to extreme slowness) I have a large Firebird 2.5 DB (a couple of tables have few millions records) to

Re: [firebird-support] Firebird 1.56 server freezing / hanging all clients (maybe during event handling)

2014-05-20 Thread Ernesto Benestante ebenesta...@gmx.net [firebird-support]
Exactly the same problem here. I'm on a different platform (Debian stable x64, Delphi app with BDE, etc), so it's most probably not a platform/toolkit issue. Did you solve the problem? EB On 15/05/14 03:12, Paul Read p...@ntasktic.com [firebird-support] wrote: Summary: All clients freeze

Re: [firebird-support] Performance of Stored Procedures versus execute blocks

2014-05-20 Thread Steve Wiser st...@specializedbusinesssoftware.com [firebird-support]
On Sun, May 18, 2014 at 6:16 AM, laf...@xietel.com [firebird-support] firebird-support@yahoogroups.com wrote: 4) SQL statements run as byte code in a “virtual machine” and are just as as speed efficient(if not more so) at data and sting manipulation (Casting, concatenation, substing and

Re: [firebird-support] Firebird 1.56 server freezing / hanging all clients (maybe during event handling)

2014-05-20 Thread Paul Read p...@ntasktic.com [firebird-support]
No. No further to resolving this issue. It maybe a network issue that is causing a serious problem for Firebird 1.56 but that is only a guess. Even more bizzare - introducing a VPN connection into the network with a client app connected over the VPN and the freezes don't happen (though only

Re: [firebird-support] Re: database became broken for any reasons

2014-05-20 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mon, May 19, 2014 at 1:31 PM, markovdmi...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: For preventing orphan pages or backversions I turn off autosweep. So for the last month I don't see any orphan pages or orphan backversions. Probably you were shutting the

Re: [firebird-support] Re: database became broken for any reasons

2014-05-20 Thread W O sistemas2000profesio...@gmail.com [firebird-support]
I like very much the way Ann explains, almost impossible to be more clear. Greetings. Walter. On Tue, May 20, 2014 at 10:47 AM, Ann Harrison aharri...@ibphoenix.com[firebird-support] firebird-support@yahoogroups.com wrote: On Mon, May 19, 2014 at 1:31 PM,

Re: [firebird-support] Re: database became broken for any reasons

2014-05-20 Thread Markov Dmitri markovdmi...@yahoo.com [firebird-support]
I turn off automatic sweep - only manual sweep. For today I try to change keepalive parameters - it's look like all ok. All processes named fb_inet_server.exe closed, but it's work if connection was lost. It's not work when the connection established and not closed for any reasons(for example

[firebird-support] Updating Firebird

2014-05-20 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Hello. I want to update Firebird from 2.5.2.26539 to 2.5.2.26540. Should I close all databases and stop de Firebird server? -- Atenciosamente, Hugo Eyng

Re: [firebird-support] Updating Firebird

2014-05-20 Thread 'H. S.' hassansha...@yahoo.com [firebird-support]
Hi 1 backup your database 2 uninstall old version 3 install last version 4 restor your database Sent from Yahoo! Mail on Android

Odp: [firebird-support] Re: database became broken for any reasons

2014-05-20 Thread 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]
Hi, Delete from mon$attachments excluding current connection After that you are only logged user Regards, Karol Bieniaszewski - Reply message - Od: Markov Dmitri markovdmi...@yahoo.com [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat:

Re: Odp: [firebird-support] Re: database became broken for any reasons

2014-05-20 Thread Markov Dmitri markovdmi...@yahoo.com [firebird-support]
It's not resolve problem, because any my application can reconnect to database. 20.05.2014 23:45, 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support] пишет: Hi, Delete from mon$attachments excluding current connection After that you are only logged user Regards,

[firebird-support] ibase_blob_echo problem

2014-05-20 Thread Mags Phangisa magut...@gmail.com [firebird-support]
Hello I have a weird problem. I have just started using ibase_blob_echo. When I retrieve the information from the table I get the correct data from the file name field and the file size field but I get 0x0001 from the blob field (using ibase_blob_echo). In a test database I got the

Re: Odp: [firebird-support] Re: database became broken for any reasons

2014-05-20 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
You might create an on connect trigger that trows an exception on certain condition, for example the value of a generator (bcause this gets visible to every transaction immediately) and for other users than yourself. That will prevent applcication from reconnecting successfully. Am 20.05.2014

Re: Odp: [firebird-support] Re: database became broken for any reasons

2014-05-20 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
You might create an on connect trigger that trows an exception on certain condition, for example the value of a generator (bcause this gets visible to every transaction immediately) and for other users than yourself. That will prevent applcication from reconnecting successfully. Am 20.05.2014