[firebird-support] Re: FB 3.0, a few questions on a new future

03.06.2016 05:24, trsk...@yahoo.com wrote: > > 1) Since FB 3.0 support WireCompression, should I still use Zebedee? No point anymore. > 2) Is that possible to hide stored procedure/trigger codes in FB 3.0 ? > Usually I used this statement : > > UPDATE RDB$TRIGGERS a set a.RDB$TRIGGER_SOURCE =

[firebird-support] Re: Simply bad, new is not always better. FB3 and ODBC

[#CORE-5210] Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work - Firebird RDBMS Issue Tracker http://tracker.firebirdsql.org/browse/CORE-5210 http://tracker.firebirdsql.org/browse/CORE-5210 [#CORE-5210] Firebird 3.0 + fbclient 3.0 - POST_EVEN...

[firebird-support] FB 3.0, a few questions on a new future

Hi guys, I am building a new project using FB 3.0 - SS, I have a few questions : 1) Since FB 3.0 support WireCompression, should I still use Zebedee? 2) Is that possible to hide stored procedure/trigger codes in FB 3.0 ? Usually I used this statement : UPDATE RDB$TRIGGERS a set

[firebird-support] Embedding 3.x into a Windwos/Mac .NET Application

Hi All, I used FireBird as a stand alone Desktop DB many years ago and would like to use it now in a new project. I'm trying to find information about embedding the latest 3.x release into my Desktop Application on Windows and Mac. I plan to use C#/.NET. I found

[firebird-support] Firebird WI-2.5.5: Super large Temp File (50+ GB)

Hello, we're using Firebird V.2.5.4 and V.2.5.5 on Windows (Superserver architecture). After the first connect to the database, firebird creates a temp file (named like "FB_TABLE_xyz" with no extension in a Windows temp directory). Initially, this file has a few hundret Kilobytes, but it is

RE: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

> >>> 3.0.1 hasn't been released yet, but snapshot builds are available here: > >>> http://www.firebirdsql.org/en/snapshot-builds/ > >>> > >> > >> the link is dead > > > > Works here. I get the entry page regarding snapshot builds for all > > branches and Windows/Linux. Anyway ... ;-) > > > >>

RE: [firebird-support] RE: Moving DB from FB 2.5.3 to FB 2.5.5

As far as I am concerned, so long as all the Firebird services aren't running (if using classic) where the databases are coming from you could just copy the files so long as the OS's are both the same type (Windows or Linux), I have certainly done it this way myself when time was short. That

Re: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

Dimitry Thanks, it works 100%, Cheers, Fabian - Original Message - From: Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] To: firebird-support@yahoogroups.com Sent: Thursday, June 02, 2016 11:17 PM Subject: Re: [firebird-support] Re: Max RAM for Database Cache in SS

[firebird-support] RE: Moving DB from FB 2.5.3 to FB 2.5.5

Hello all, I have 2 database servers running on Linux. One is running FB 2.5.3 and the other is running FB 2.5.5. The hardware is the same 64bit architecture for both servers. I need to move some databases from the 2.5.3 server to the 2.5.5 server. Provided the FB service is down so the

Re: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

Anto Could you let me know how you setup the DB cache value? I mean what tool or sentence are you using to set it and then check it, because I am having trouble setting the value above 131071 pages with IBexpert, probably an IBExpert bug, but I just want to be sure it is not something else,

[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

Dear all, Sorry, I have miscalculated the setting in DefaultDbCachePages, it was set more than available RAM on my Computer, no wonder it crashed. Now, everything is OK, tested on SS FB 3.0 in Win64. Thanks for your helps, Best regards, Anto.

Re: [firebird-support] Re: FB 3.0, got problem when add field to Table with existing data

Dear Mark, Thanks for you info, solved the problem. Regards, Anto.

Re: [firebird-support] Re: FB 3.0, got problem when add field to Table with existing data

On 2016-06-02 6:20, trsk...@yahoo.com [firebird-support] wrote: >> What value must it have? Add a default clause to this statement. Or > add > > the field as nullable, populate with data and then alter to NOT > NULL. > > I have tried to add field as nullable, then tried to alter to not > null. >

[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

> ---In firebird-support@yahoogroups.com, wrote : >> Setting DefaultDbCachePages more than allowed caused a crashed. > Try a v3.0.1 snapshot build, IIRC it was fixed recently. If you mean CORE-5240 - it was a bug in v 2.5 only, i.e. v3 is not affected Regards, Vlad

[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

> ---In firebird-support@yahoogroups.com, wrote : > > Hi guys, > > Am I correct that maximum allowed RAM for database cache on SS FB 3.0 in > Win64 is only 2 GB? > Calculated from max DefaultDbCachePages (131072) x max Page Size (16384) = 2 > GB. No. This is limit for

Re: [firebird-support] Re: Issue with Database Cache Size on FB 3.0

> ---In firebird-support@yahoogroups.com, wrote : > > Something funny is going on regarding the memory consumption, I have > > attached screenshots showing the memory counters. > If you look at the process itself (file > TaskManager_Process_Firebird_Only_Consumed_2GB.jpg), it

[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] a écrit : >> 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] a écrit : >>> trsk...@yahoo.com [firebird-support] schrieb am 02.06.2016 06:44: >>> Where I can download v3.0.1 ? >>> >>> 3.0.1 hasn't been released yet,

Re: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

> 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] a écrit : >> trsk...@yahoo.com [firebird-support] schrieb am 02.06.2016 06:44: >> >>> Where I can download v3.0.1 ? >> >> 3.0.1 hasn't been released yet, but snapshot builds are available here: >>

[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] a écrit : > trsk...@yahoo.com [firebird-support] schrieb am 02.06.2016 06:44: > >> Where I can download v3.0.1 ? > > 3.0.1 hasn't been released yet, but snapshot builds are available here: >

Re: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

trsk...@yahoo.com [firebird-support] schrieb am 02.06.2016 06:44: > Where I can download v3.0.1 ? 3.0.1 hasn't been released yet, but snapshot builds are available here: http://www.firebirdsql.org/en/snapshot-builds/ -- With regards, Thomas Steinmaurer http://www.upscene.com Professional

Re: [firebird-support] Re: FB 3.0, got problem when add field to Table with existing data

>> What value must it have? Add a default clause to this statement. Or add > > the field as nullable, populate with data and then alter to NOT NULL. > > I have tried to add field as nullable, then tried to alter to not null. > > UPDATE TMP_RPT SET ID1 = '5'; Commit; > (This statement is OK) >