[firebird-support] Database as own security database

I am upgrading from 2.1 to 3.02 and I want a database to be its own security database. If I register the database as: ABZ = {path to database file} { SecurityDatabase = ABZ } then I cannot restore from the backup because there is no security context. If I restore as a normal database I cannot

Re: [firebird-support] Using Firebird v3.0.2 fbclient.dll to access previous versions, specifically 1,56

On 2017-12-06 13:14, OB1 oldbasf...@googlemail.com [firebird-support] wrote: > We're making the jump from v1.56 to v3.0.2 (gulp!) and to make the > transition easier for our clients we wondered if v3 client libs > (fbclient.dll) can access 1.56 servers. We've tested this and it > appears to

RE: [firebird-support] Re: Slow execution of Stored Procedure after 20 min. inactivity

> ---In firebird-support@yahoogroups.com, wrote : > > With “idle” I mean no connections at all. > I already found out the problem is related to a custom UDF dll, but it’s > unclear to me why this only happens after 20 minutes. > I added some logging to the UDF so I could see when

Re: [firebird-support] Re: lock denied...

Hi, here is the link: https://ulozto.net/!wM4fFP0Kpnuq/fb-lock-table-dump There are options "Fast download" and "Slow download". If you don't want to register then you must use "Slow download" and type captcha code. Jakub -- Původní e-mail -- Od: peshk...@mail.ru

[firebird-support] Using Firebird v3.0.2 fbclient.dll to access previous versions, specifically 1,56

We're making the jump from v1.56 to v3.0.2 (gulp!) and to make the transition easier for our clients we wondered if v3 client libs (fbclient.dll) can access 1.56 servers. We've tested this and it appears to work, but wanted to confirm if it was officially supported. Many thanks.

RE: [firebird-support] Re: Slow execution of Stored Procedure after 20 min. inactivity

Hello, With “idle” I mean no connections at all. I already found out the problem is related to a custom UDF dll, but it’s unclear to me why this only happens after 20 minutes. I added some logging to the UDF so I could see when the UDF was loaded and unloaded and the memory usage at those

[firebird-support] info

select   gen_id(GEN_XXX, 1) from RDB$DATABASE Where GEN_XXX - generator for your A.ID column

[firebird-support] Re: Slow execution of Stored Procedure after 20 min. inactivity

> ---In firebird-support@yahoogroups.com, wrote : > > Hello, > > After spending more than a week trying to resolve the following issue we hope > someone has an answer on this. > > We have a database with about 230 tables and 200 stored procedures which is > being used by our

Re: [firebird-support] Re: lock denied...

First of all regarding yesterday file. Unfortunately "Non-text portions of thAT message have been removed". So please upload that file to any public file-sharing you better like (except yandex & mail.ru). Sorry for inconveniences - that's not me who invited yahoo interface... > But you should

Re: [firebird-support] windows server 2016 as server for firebird 2.5.7

Hello Nils, No other issues. Regards, Alexey Kovyazin IBSurgeon On 05.12.2017 14:52, Nils Boedeker nilsboede...@t-online.de [firebird-support] wrote: Hi I want to use windows server 2016 as server for firebird 2.5.7 (Classic Server) are there any known issus with using firebird with

[firebird-support] info

Hello, Ex. Table A Id (AutoInc) Description Id = 1 / Description = Test Id = 2 / Description = Test2 I want to know the next Id number in my table without an insert. In my example it will be 3. I want to reserve (without an insert) Id number 3 because someone else can also ask the next Id

Re: [firebird-support] Re: lock denied...

It's me again. FB3 in SuperServer mode seems to run without any trouble for almost the whole day. Anyway, if you are interested I offer you that I might prepare second test server with almost the same SW and very similar load and FB in SuperClient mode. But you should write me what and where