Re: [firebird-support] UPDATE OR INSERT in Firebird 3

['Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]]

Hello River

Thanks for your suggestion but I need to use UPDATE OR INSERT.

I know that an INSERT without an IDENTITY column will work well. That's not
the problem.

But I never use INSERT, I always use UPDATE OR INSERT.

And with an IDENTITY column it is impossible to use UPDATE OR INSERT
therefore the IDENTITY columns are useless for me and I have returned to
the old and well fashioned generator/trigger method.

I have installed Firebird 2.5.9 and Firebird 3.0.7 because there are dozens
of applications using Firebird 2.5 and my new application is using Firebird
3.

So far, the only problem I have found with Firebird 3 is that IDENTITY
columns can not be used with UPDATE OR INSERT.

Greetings.

Walter.






Libre
de virus. www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Wed, Nov 25, 2020 at 6:13 AM 'River~~' river14ap...@gmail.com
[firebird-support]  wrote:

>
>
> hi Walter
>
> Try
>
> INSERT INTO mytable(column2) VALUES (12345)
>
> In other words, do not try to insert the column you want to be
> auto-generated. The database engine will notice that you are inserting
> only a subset of the columns, and SHOULD use the default values for
> the missing columns, which would be NULL unless you specified
> otherwise. In the case of column1 you have specified that the default
> value would be the auto-incremented value. If your table has a
> column3 then you should find that is set to NULL by my suggested
> syntax.
>
> I do not have v3 running currently so cannot test it myself, so please
> report back for the benefit of myself and everyone else whether that
> works for you or not.
>
> I am also interested to know if you find my syntax works on v2.5, if
> you still have it installed to test it? Please don't go to the trouble
> of re-installing it just to test it.
>
> It is arguable that v3 is correct in rejecting the syntax you have
> previously used, because it does not make logical sense to tell the
> database engine to insert a null when you mean something else. The
> syntax I suggested will be more portable to other db engines because
> it is closer to the standard.
>
> I hope that suggestion proves helpful
> Warmly
> River~~
>
> On 19/11/2020, 'Walter R. Ojeda Valiente'
> sistemas2000profesio...@gmail.com [firebird-support]
>  wrote:
> > Hello everybody
> >
> > A long, long time without writing neither reading this group, mostly
> > because all that I need about Firebird I knew.
> >
> > But now, I have a doubt.
> >
> > With Firebird 2.5.x I can have an auto-incremental column and use it in
> an
> > UPDATE OR INSERT, but such thing is not possible with Firebird 3.
> >
> > With Firebird 2.5.x a generator and a trigger are created and the value
> of
> > the column is put automatically. So, if I write:
> > UPDATE OR INSERT INTO MyTable (MyColumn1, MyColumn2) VALUES (NULL,
> 12345);
> >
> > and MyColumn1 is auto-incremental its value is set for the Firebird
> engine.
> >
> > but...if I use the new IDENTITY type in Firebird 3 I always have an
> error,
> > writing MyColumn1 in the UPDATE OR INSERT or not writing.
> >
> > So, my question is:
> >
> > Is it possible to use UPDATE OR INSERT with an IDENTITY column?
> >
> > Thanks in advance.
> >
> > Greetings.
> >
> > Walter.
> >
>
> --
> 9831*2^1441403+1 is prime, >400k digits
> 
>

Re: [firebird-support] UPDATE OR INSERT in Firebird 3

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 25-11-2020 10:13, 'River~~' river14ap...@gmail.com [firebird-support] 
wrote:
[..]
> I am also interested to know if you find my syntax works on v2.5, if
> you still have it installed to test it? Please don't go to the trouble
> of re-installing it just to test it.
> 
> It is arguable that v3 is correct in rejecting the syntax you have
> previously used, because it does not make logical sense to tell the
> database engine to insert a null when you mean something else. The
> syntax I suggested will be more portable to other db engines because
> it is closer to the standard.

That is not the problem, the solution Walter used in Firebird 2.5 would 
work in Firebird 3 as well. The problem is that Walter switched from 
auto-increment columns generated by a trigger, to using identity columns.

When you use a trigger, you can explicitly handle null to generate a 
value, but when using an identity column, then you either have to leave 
out the column so it is generated, or you need to specify a non-null value.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] UPDATE OR INSERT in Firebird 3

['River~~' river14ap...@gmail.com [firebird-support]]

hi  Walter

Try

INSERT INTO mytable(column2) VALUES (12345)

In other words, do not try to insert the column you want to be
auto-generated. The database engine will notice that you are inserting
only a subset of the columns, and SHOULD use the default values for
the missing columns, which would be NULL unless you specified
otherwise. In the case of column1 you have specified that the default
value  would be the auto-incremented value. If your table has a
column3 then you should find that is set to NULL by my suggested
syntax.

I do not have v3 running currently so cannot test it myself, so please
report back for the benefit of myself and everyone else whether that
works for you or not.

I am also interested to know if you find my syntax works on v2.5, if
you still have it installed to test it? Please don't go to the trouble
of re-installing it just to test it.

It is arguable that v3 is correct in rejecting the syntax you have
previously used, because it does not make logical sense to tell the
database engine to insert a null when you mean something else. The
syntax I suggested will be more portable to other db engines because
it is closer to the standard.

I hope that suggestion proves helpful
Warmly
River~~

On 19/11/2020, 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com [firebird-support]
 wrote:
> Hello everybody
>
> A long, long time without writing neither reading this group, mostly
> because all that I need about Firebird I knew.
>
> But now, I have a doubt.
>
> With Firebird 2.5.x I can have an auto-incremental column and use it in an
> UPDATE OR INSERT, but such thing is not possible with Firebird 3.
>
> With Firebird 2.5.x a generator and a trigger are created and the value of
> the column is put automatically. So, if I write:
> UPDATE OR INSERT INTO MyTable (MyColumn1, MyColumn2) VALUES (NULL, 12345);
>
> and MyColumn1 is auto-incremental its value is set for the Firebird engine.
>
> but...if I use the new IDENTITY type in Firebird 3 I always have an error,
> writing MyColumn1 in the UPDATE OR INSERT or not writing.
>
> So, my question is:
>
> Is it possible to use UPDATE OR INSERT with an IDENTITY column?
>
> Thanks in advance.
>
> Greetings.
>
> Walter.
>


-- 
9831*2^1441403+1 is prime, >400k digits

Re: [firebird-support] Re: UPDATE OR INSERT in Firebird 3

['Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]]

Hello Daniel

Yes, I agree with you, IDENTITY columns are useless for me, so I quit using
them. Maybe for a log table or something so can serve, but for normal work
they are useless.

I had returned to the old and well suitable practice of generator/trigger,
so with a short stored procedure I can INSERT and UPDATE too. Fewer lines
of code are a good practice according to my point of view.

Greetings.

Walter.


On Tue, Nov 24, 2020 at 3:32 PM Daniel Miller dmil...@amfes.com
[firebird-support]  wrote:

>
>
> I experimented with IDENTITY fields myself - based on my experience and
> some older comments here I quit using them. I think they are presently
> suitable for "quick" tables - something that will be append only like a log.
>
> If you're looking for more advanced features, like supporting UPDATE OR
> INSERT (which I use myself), then you're much better off explicitly writing
> the appropriate insert and update triggers. Possibly version 4 will
> implement IDENTITY better but I don't use it all now.
>
> Daniel
>
> On 11/20/2020 5:59 AM, 'Walter R. Ojeda Valiente'
> sistemas2000profesio...@gmail.com [firebird-support] wrote:
>
> 
>

Re: [firebird-support] Re: UPDATE OR INSERT in Firebird 3

[Daniel Miller dmil...@amfes.com [firebird-support]]

I experimented with IDENTITY fields myself - based on my experience and 
some older comments here I quit using them. I think they are presently 
suitable for "quick" tables - something that will be append only like a log.


If you're looking for more advanced features, like supporting UPDATE OR 
INSERT (which I use myself), then you're much better off explicitly 
writing the appropriate insert and update triggers. Possibly version 4 
will implement IDENTITY better but I don't use it all now.


Daniel

On 11/20/2020 5:59 AM, 'Walter R. Ojeda Valiente' 
sistemas2000profesio...@gmail.com [firebird-support] wrote:



Hello Herman

I had used UPDATE OR INSERT for several years in several hundred of 
tables. No problem...with Firebird 2.5.x


But with Firebird 3.0.x I can not make it work.

If I write the identity column, doesn't work. If I don't write the 
identity column, doesn't work..


Thank you very much for your answer.

Greetings.

Walter.



On Fri, Nov 20, 2020 at 6:16 AM Herman Viaene herman.via...@edpnet.be 
 [firebird-support] 
> wrote:


Op 20/11/2020 om 01:04 schreef 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com
 [firebird-support]:

I use firebird3 from libreoffice base, not directly, but in that
way I can make (and have done) such insert stattements.

CREATE TABLE MYTABLE (
  COLUMN1 INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1)
NOT NULL,
  COLUMN2 VARCHAR(20));


ALTER TABLE MYTABLE ADD CONSTRAINT PK_MYTABLE PRIMARY KEY (COLUMN1);


I have similar tables



Then, is I write it:
UPDATE OR INSERT INTO MYTABLE (COLUMN1, COLUMN2) VALUES (NULL,
'TEST')

The message is:
Validation error for column "MYTABLE"."COLUMN1", value "*** null
***".


That is quite normal and correct, since you define column1 as not
null, and now you try to insert a null value in it.



And if I write it:
UPDATE OR INSERT INTO MYTABLE (COLUMN2) VALUES ('TEST')


I have written similar insert statements and they work OK, BUT: I
write either an insert statement OR an update statement. The two
are fundamentally different as to the primary key handling:
in an insert statement you do not give a value to the PK, since it
is generated by the system.
in an update statement you have to define on which rows (all or by
giving a value for the PK or by a select statement) the update has
to apply.

I must confess I've never tried to use "UPDATE OR INSERT", and I
wonder about it.  I googled and checked the syntax, and I think
your statement will try to match your value 'TEST' against the PK,
and that does not work of course. You would have to use the
"matching (column2)" in your statement.

Just my 2c

Herman Viaene





The message is:
UPDATE OR INSERT field list does not match primary key of table
MYTABLE.


There is some solution? Or it is impossible to use an IDENTITY
column with an UPDATE OR INSERT?

Greetings.

Walter.




On Thu, Nov 19, 2020 at 8:55 PM Walter R. Ojeda Valiente
mailto:sistemas2000profesio...@gmail.com>> wrote:

I forget to say that my IDENTITY column is the Primary Key of
MyTable, therefore if I don't write it an error happens
because...the table needs a Primary Key.

On Thu, Nov 19, 2020 at 8:52 PM Walter R. Ojeda Valiente
mailto:sistemas2000profesio...@gmail.com>> wrote:

Hello everybody

A long, long time without writing neither reading this
group, mostly because all that I need about Firebird I knew.

But now, I have a doubt.

With Firebird 2.5.x I can have an auto-incremental column
and use it in an UPDATE OR INSERT, but such thing is not
possible with Firebird 3.

With Firebird 2.5.x a generator and a trigger are created
and the value of the column is put automatically. So, if
I write:
UPDATE OR INSERT INTO MyTable (MyColumn1, MyColumn2)
VALUES (NULL, 12345);

and MyColumn1 is auto-incremental its value is set for
the Firebird engine.

but...if I use the new IDENTITY type in Firebird 3 I
always have an error, writing MyColumn1 in the UPDATE OR
INSERT or not writing.

So, my question is:

Is it possible to use UPDATE OR INSERT with an IDENTITY
column?

Thanks in advance.

Greetings.

Walter.

Re: [firebird-support] Re: UPDATE OR INSERT in Firebird 3

['Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]]

Hello Herman

I had used UPDATE OR INSERT for several years in several hundred of tables.
No problem...with Firebird 2.5.x

But with Firebird 3.0.x I can not make it work.

If I write the identity column, doesn't work. If I don't write the identity
column, doesn't work.

Thank you very much for your answer.

Greetings.

Walter.



On Fri, Nov 20, 2020 at 6:16 AM Herman Viaene herman.via...@edpnet.be
[firebird-support]  wrote:

>
>
> Op 20/11/2020 om 01:04 schreef 'Walter R. Ojeda Valiente'
> sistemas2000profesio...@gmail.com [firebird-support]:
>
> I use firebird3 from libreoffice base, not directly, but in that way I can
> make (and have done) such insert stattements.
>
>
> CREATE TABLE MYTABLE (
>   COLUMN1 INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
>   COLUMN2 VARCHAR(20));
>
>
> ALTER TABLE MYTABLE ADD CONSTRAINT PK_MYTABLE PRIMARY KEY (COLUMN1);
>
>
> I have similar tables
>
>
> Then, is I write it:
> UPDATE OR INSERT INTO MYTABLE (COLUMN1, COLUMN2) VALUES (NULL, 'TEST')
>
> The message is:
> Validation error for column "MYTABLE"."COLUMN1", value "*** null ***".
>
>
> That is quite normal and correct, since you define column1 as not null,
> and now you try to insert a null value in it.
>
>
> And if I write it:
> UPDATE OR INSERT INTO MYTABLE (COLUMN2) VALUES ('TEST')
>
>
> I have written similar insert statements and they work OK, BUT: I write
> either an insert statement OR an update statement. The two are
> fundamentally different as to the primary key handling:
> in an insert statement you do not give a value to the PK, since it is
> generated by the system.
> in an update statement you have to define on which rows (all or by giving
> a value for the PK or by a select statement) the update has to apply.
>
> I must confess I've never tried to use "UPDATE OR INSERT", and I wonder
> about it.  I googled and checked the syntax, and I think your statement
> will try to match your value 'TEST' against the PK, and that does not work
> of course. You would have to use the "matching (column2)" in your statement.
>
> Just my 2c
>
> Herman Viaene
>
>
>
>
> The message is:
> UPDATE OR INSERT field list does not match primary key of table MYTABLE.
>
>
> There is some solution? Or it is impossible to use an IDENTITY column with
> an UPDATE OR INSERT?
>
> Greetings.
>
> Walter.
>
>
>
>
> On Thu, Nov 19, 2020 at 8:55 PM Walter R. Ojeda Valiente <
> sistemas2000profesio...@gmail.com> wrote:
>
>> I forget to say that my IDENTITY column is the Primary Key of MyTable,
>> therefore if I don't write it an error happens because...the table needs a
>> Primary Key.
>>
>> On Thu, Nov 19, 2020 at 8:52 PM Walter R. Ojeda Valiente <
>> sistemas2000profesio...@gmail.com> wrote:
>>
>>> Hello everybody
>>>
>>> A long, long time without writing neither reading this group, mostly
>>> because all that I need about Firebird I knew.
>>>
>>> But now, I have a doubt.
>>>
>>> With Firebird 2.5.x I can have an auto-incremental column and use it in
>>> an UPDATE OR INSERT, but such thing is not possible with Firebird 3.
>>>
>>> With Firebird 2.5.x a generator and a trigger are created and the value
>>> of the column is put automatically. So, if I write:
>>> UPDATE OR INSERT INTO MyTable (MyColumn1, MyColumn2) VALUES (NULL,
>>> 12345);
>>>
>>> and MyColumn1 is auto-incremental its value is set for the Firebird
>>> engine.
>>>
>>> but...if I use the new IDENTITY type in Firebird 3 I always have an
>>> error, writing MyColumn1 in the UPDATE OR INSERT or not writing.
>>>
>>> So, my question is:
>>>
>>> Is it possible to use UPDATE OR INSERT with an IDENTITY column?
>>>
>>> Thanks in advance.
>>>
>>> Greetings.
>>>
>>> Walter.
>>>
>> 
>

Re: [firebird-support] Re: UPDATE OR INSERT in Firebird 3

[Herman Viaene herman.via...@edpnet.be [firebird-support]]

Op 20/11/2020 om 01:04 schreef 'Walter R. Ojeda Valiente' 
sistemas2000profesio...@gmail.com [firebird-support]:


I use firebird3 from libreoffice base, not directly, but in that way I 
can make (and have done) such insert stattements.

CREATE TABLE MYTABLE (
  COLUMN1 INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT 
NULL,

  COLUMN2 VARCHAR(20));


ALTER TABLE MYTABLE ADD CONSTRAINT PK_MYTABLE PRIMARY KEY (COLUMN1);


I have similar tables



Then, is I write it:
UPDATE OR INSERT INTO MYTABLE (COLUMN1, COLUMN2) VALUES (NULL, 'TEST')

The message is:
Validation error for column "MYTABLE"."COLUMN1", value "*** null ***".


That is quite normal and correct, since you define column1 as not null, 
and now you try to insert a null value in it.




And if I write it:
UPDATE OR INSERT INTO MYTABLE (COLUMN2) VALUES ('TEST')


I have written similar insert statements and they work OK, BUT: I write 
either an insert statement OR an update statement. The two are 
fundamentally different as to the primary key handling:
in an insert statement you do not give a value to the PK, since it is 
generated by the system.
in an update statement you have to define on which rows (all or by 
giving a value for the PK or by a select statement) the update has to apply.


I must confess I've never tried to use "UPDATE OR INSERT", and I wonder 
about it.  I googled and checked the syntax, and I think your statement 
will try to match your value 'TEST' against the PK, and that does not 
work of course. You would have to use the "matching (column2)" in your 
statement.


Just my 2c

Herman Viaene





The message is:
UPDATE OR INSERT field list does not match primary key of table MYTABLE.


There is some solution? Or it is impossible to use an IDENTITY column 
with an UPDATE OR INSERT?


Greetings.

Walter.




On Thu, Nov 19, 2020 at 8:55 PM Walter R. Ojeda Valiente 
> wrote:


I forget to say that my IDENTITY column is the Primary Key of
MyTable, therefore if I don't write it an error happens
because...the table needs a Primary Key.

On Thu, Nov 19, 2020 at 8:52 PM Walter R. Ojeda Valiente
mailto:sistemas2000profesio...@gmail.com>> wrote:

Hello everybody

A long, long time without writing neither reading this group,
mostly because all that I need about Firebird I knew.

But now, I have a doubt.

With Firebird 2.5.x I can have an auto-incremental column and
use it in an UPDATE OR INSERT, but such thing is not possible
with Firebird 3.

With Firebird 2.5.x a generator and a trigger are created and
the value of the column is put automatically. So, if I write:
UPDATE OR INSERT INTO MyTable (MyColumn1, MyColumn2) VALUES
(NULL, 12345);

and MyColumn1 is auto-incremental its value is set for the
Firebird engine.

but...if I use the new IDENTITY type in Firebird 3 I always
have an error, writing MyColumn1 in the UPDATE OR INSERT or
not writing.

So, my question is:

Is it possible to use UPDATE OR INSERT with an IDENTITY column?

Thanks in advance.

Greetings.

Walter.





--
Plus je dors, mieux je me porte (Gaston Lagaffe)

Hoe meer ik slaap, hoe beter ik me voel (Guus Flater)

The more I sleep, the better I feel (Gomer Goof)

Re: [firebird-support] Support native JSON datatype for columns as MySQL / PostgreeSql

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 13-10-2020 18:42, 'P-Soft - Fabio Codebue' f.code...@p-soft.biz 
[firebird-support] wrote:
> 
> 
> Support native JSON datatype for columns as MySQL / PostgreeSql
> 
> Some idea when this feateures will be scheduled?
> Or we are not be interested on it?

There is a ticket in the tracker: 
http://tracker.firebirdsql.org/browse/CORE-5148

But it is not planned for any version so far.

Mark

-- 
Mark Rotteveel

Re: [firebird-support] is it a bug?

['River~~' river14ap...@gmail.com [firebird-support]]

I think this behaviour is consistent with the ANSI standard. The double
quotes are necessary (if my memory serves me correctly) if there are
characters in the user name that are not letters numbers and underscores.
Maybe hyphens/minus are allowed also. But it's the dot that is annoying the
database.

You might like to experiment and see what happens if you put dots in some
of the other values. That would show where FB3 objects because it's a user
name, or would object anyway.

In my experience, these kinds of issues often turn up when using a new
database engine: no two vendors seen to have read the same standard!

Most DBMSs are less pedantic about this sort of thing, but you can't really
hold it against FB3 if it follows the standard more closely than other
implementors of  SQL.

R~~

On 14:25, Tue, 28 Jul 2020 hamacker sirhamac...@gmail.com
[firebird-support] 
>
> If I try in FB3 (latest version):
> CREATE
>   USER  'ROBOT.CUSTOS' -- wont run
>   PASSWORD  'password'
>   FIRSTNAME 'ROBOT'
>   MIDDLENAME 'DE'
>   LASTNAME 'CUSTOS' ;
>
> Not run! but If I try:
>   CREATE
>   USER  "ROBOT.CUSTOS" -- it´s run
>   PASSWORD  'password'
>   FIRSTNAME 'ROBOT'
>   MIDDLENAME 'DE'
>   LASTNAME 'CUSTOS' ;
>
> I think that double quotes are used only if you want case sensitive, but I
> see that only method to create login with "." and maybe others separators..
> 
>

Re: [firebird-support] is it a bug?

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

The firebird-support Yahoo Group has moved to Google Groups at 
https://groups.google.com/d/forum/firebird-support. Please subscribe and 
post your question there.

Mark

On 2020-07-28 15:23, hamacker sirhamac...@gmail.com [firebird-support] 
wrote:
> If I try in FB3 (latest version):CREATE
>   USER  'ROBOT.CUSTOS' -- wont run
>   PASSWORD  'password'
>   FIRSTNAME 'ROBOT'
>   MIDDLENAME 'DE'
>   LASTNAME 'CUSTOS' ;
> 
> Not run! but If I try:
>   CREATE
>   USER  "ROBOT.CUSTOS" -- it´s run
>   PASSWORD  'password'
>   FIRSTNAME 'ROBOT'
>   MIDDLENAME 'DE'
>   LASTNAME 'CUSTOS' ;
> 
> I think that double quotes are used only if you want case sensitive,
> but I see that only method to create login with "." and maybe others
> separators.

Re: [firebird-support] is it a bug?

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

28.07.2020 15:23, hamacker sirhamac...@gmail.com [firebird-support] wrote:
> I think that double quotes are used only if you want case sensitive

   They are required for any SQL identifier that contains non-allowed 
characters.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 25-06-2020 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
[firebird-support] wrote:
> Is it possible to create databases on a 3.0.5 server with a user other 
> than sysdba?
> when i try in flamerobin create a database with another user it gives me 
> the following error:
> Context:Database::Create
> Message:isc_dsql_execute_immediate failed
> SQL Message:-551
> This user not have privilege to perform this operation on this object
> Engine Code :335544352
> no permission for CREATE access to DATABASE /mnt/ccs/test.fdb

See also 
https://firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/qsg3-databases.html#qsg3-databases-creating-nonsysdba

-- 
Mark Rotteveel

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

Thank you, I will follow your instructions.
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan
- Original Message - 
From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 

To: 
Sent: Friday, June 26, 2020 3:34 PM
Subject: Re: [firebird-support] error when trying to open databases 2.5 on 
server 3.0.5


> 26.06.2020 21:08, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
> [firebird-support] wrote:
>> I don't know if I will be such a novice, but I can't find the language
>> reference manual for firebird 3
>
> https://firebirdsql.org/en/reference-manuals/
>
>   Google Translate can help you read it.
>
> -- 
>   WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu 
> there.
>
> Also search the knowledgebases at 
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
> 








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 26-06-2020 21:08, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
[firebird-support] wrote:
> I don't know if I will be such a novice, but I can't find the language
> reference manual for firebird 3

It is documented in the release notes: 
https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-access-sql.html#rnfb30-security-metadataprivs

PS. Please move this discussion to the new firebird-support list on 
Googlegroups.
-- 
Mark Rotteveel

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

26.06.2020 21:08, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
[firebird-support] wrote:
> I don't know if I will be such a novice, but I can't find the language
> reference manual for firebird 3

https://firebirdsql.org/en/reference-manuals/

   Google Translate can help you read it.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

I don't know if I will be such a novice, but I can't find the language 
reference manual for firebird 3

I install firebird3 in devuan which is the operating system I use and it 
asks me for the password of the user sysdba.

Then if I create the user from flamerobin or using gsec it never lets me use 
that user that I create to create a new database, that has never happened to 
me with firebird 2.5.x

And the truth is that I have tried in several ways, but the truth did not 
achieve positive results.

Can't someone give me a more detailed explanation of how to create a 
database in firebird 3 with a user other than sysdba?

I know that time is money, but I do not think that it is so much for those 
who really have the knowledge of how to do it, I have already searched the 
internet and I have not found it, perhaps it is not possible to search there 
either.

Best regards
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan
- Original Message - 
From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 

To: 
Sent: Thursday, June 25, 2020 3:18 PM
Subject: Re: [firebird-support] error when trying to open databases 2.5 on 
server 3.0.5


> 25.06.2020 20:50, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
> [firebird-support] wrote:
>> And how do I assign the pre-benefits to the user that I am going to use 
>> to
>> create the database?
>
>   Using "GRANT" statement as described in Language Reference.
>
> -- 
>   WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu 
> there.
>
> Also search the knowledgebases at 
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
> 








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

25.06.2020 20:50, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
[firebird-support] wrote:
> And how do I assign the pre-benefits to the user that I am going to use to
> create the database?

   Using "GRANT" statement as described in Language Reference.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

And how do I assign the pre-benefits to the user that I am going to use to 
create the database?

Reiterated greetings
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan

- Original Message - 
From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 

To: 
Sent: Thursday, June 25, 2020 11:07 AM
Subject: Re: [firebird-support] error when trying to open databases 2.5 on 
server 3.0.5


> 25.06.2020 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
> [firebird-support] wrote:
>> Is it possible to open database 2.5.9 on servers 3.0.5?
>
>   No.
>
>> Is it possible to create databases on a 3.0.5 server with a user other 
>> than sysdba?
>
>   Yes, but appropriate privilege must be granted to the user.
>
>   Actually it is plainly written in the error messages.
>
> -- 
>   WBR, SD.
>
>








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

You have sent your email to the old list, please post to the new list at 
firebird-supp...@googlegroups.com (or 
https://groups.google.com/d/forum/firebird-support).

If you're not subscribed yet, you can do it on above link, or by sending 
an email to firebird-support+subscr...@googlegroups.com (if your email 
address is not associated with a Google account, make sure to confirm by 
replying to the email).

Mark

On 2020-06-25 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
[firebird-support] wrote:
> Is it possible to open database 2.5.9 on servers 3.0.5?
> 
> when I try to open it with flamerobin it gives me the following error:
> 
> Context:Database::Connect
> Message:isc_attach_database failed
> 
> SQL Message:-820
> wrong or obsolete version
> 
> Engine Code :335544379
> Engine Message:
> unsupported on-disk structure for file /mnt/ccs/libsc.fdb; found 11.2,
> support 12.2
> IProvider::attachDatabase failed when loading mapping cache
> 
> Is it possible to create databases on a 3.0.5 server with a user other
> than sysdba?
> 
> when i try in flamerobin create a database with another user it gives
> me the following error:
> Context:Database::Create
> Message:isc_dsql_execute_immediate failed
> 
> SQL Message:-551
> This user not have privilege to perform this operation on this object
> 
> Engine Code :335544352
> no permission for CREATE access to DATABASE /mnt/ccs/test.fdb

RE: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

['Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]]

Release Notes

"New ODS Number
Firebird 3.0 creates databases with an ODS (On-Disk Structure) version of 12. 
In the initial release, a database
with an older ODS cannot be opened by Firebird 3.0. In order to work with a 
database with an older ODS it will
be necessary to make a backup using gbak  under the older server and restore it 
with gbak on Firebird 3.
Note
A legacy provider for databases with ODS 8 to 11.2 is planned for a future 
sub-release"

Paul
-Original Message-
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 25 June 2020 16:46
To: Firebird Support
Subject: [firebird-support] error when trying to open databases 2.5 on server 
3.0.5



Is it possible to open database 2.5.9 on servers 3.0.5?

when I try to open it with flamerobin it gives me the following error:
Context:Database::Connect
Message:isc_attach_database failed

SQL Message:-820
wrong or obsolete version

Engine Code :335544379
Engine Message:
unsupported on-disk structure for file /mnt/ccs/libsc.fdb; found 11.2, support 
12.2
IProvider::attachDatabase failed when loading mapping cache

Is it possible to create databases on a 3.0.5 server with a user other than 
sysdba?

when i try in flamerobin create a database with another user it gives me the 
following error:
Context:Database::Create
Message:isc_dsql_execute_immediate failed

SQL Message:-551
This user not have privilege to perform this operation on this object

Engine Code :335544352
no permission for CREATE access to DATABASE /mnt/ccs/test.fdb

Best Regards
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

25.06.2020 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
[firebird-support] wrote:
> Is it possible to open database 2.5.9 on servers 3.0.5?

   No.

> Is it possible to create databases on a 3.0.5 server with a user other than 
> sysdba?

   Yes, but appropriate privilege must be granted to the user.

   Actually it is plainly written in the error messages.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Error Loading Pluggin Engine12

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

24.06.2020 14:20, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> the issue is not resolved. Now it complains the database does not exist.

   That's another issue. Check that path and name of database are right.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Error Loading Pluggin Engine12

[LtColRDSChauhan rdsc1...@gmail.com [firebird-support]]

On Wed, 24 Jun 2020, 4:47 pm Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support],  wrote:

> 24.06.2020 13:14, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > the Process Explorer reports the dll as under  :
> >
> > D:\Program Files\Firebird\Firebird_3_0\WOW64\fbclient.dll
>
>That's the problem. This library must not be used from this place but
> copied into
> %WINDOWS%\SysWOW64\ (or anywhere else).
>
>
The fbclient.dll file already existed in the  %WINDOWS%\SysWOW64\ folder so
rechecked again after removing the fbclient.dll in the D:\Program
Files\Firebird\Firebird_3_0\WOW64\ directory, the issue is not resolved.
Now it complains the database does not exist.


> The library already exists in the SysWOW64 folder. So now trie
> --
>WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] Error Loading Pluggin Engine12

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

24.06.2020 13:14, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> the Process Explorer reports the dll as under  :
> 
> D:\Program Files\Firebird\Firebird_3_0\WOW64\fbclient.dll

   That's the problem. This library must not be used from this place but copied 
into 
%WINDOWS%\SysWOW64\ (or anywhere else).

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Error Loading Pluggin Engine12

[LtColRDSChauhan rdsc1...@gmail.com [firebird-support]]

On Wed, Jun 24, 2020 at 2:10 PM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support]  wrote:

> 24.06.2020 03:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > Use Process Explorer to find out which exactly fbclient.dll is
> loaded.
> >
> > I do not find fbclient.dll listed in the Task Manager of the client
> Windows machine when i
> > attempt to connect to the Firebird on the remote Ubuntu machine using
> flamerobin on the
> > Windows client machine.
>
>In this case you must use Process Explorer instead of Task Manger.
>
>
the Process Explorer reports the dll as under  :

D:\Program Files\Firebird\Firebird_3_0\WOW64\fbclient.dll


> --
>WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] Error Loading Pluggin Engine12

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

24.06.2020 03:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
>     Use Process Explorer to find out which exactly fbclient.dll is loaded.
> 
> I do not find fbclient.dll listed in the Task Manager of the client Windows 
> machine when i 
> attempt to connect to the Firebird on the remote Ubuntu machine using 
> flamerobin on the 
> Windows client machine.

   In this case you must use Process Explorer instead of Task Manger.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Error Loading Pluggin Engine12

[LtColRDSChauhan rdsc1...@gmail.com [firebird-support]]

On Tue, Jun 23, 2020 at 9:53 PM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support]  wrote:

> 23.06.2020 18:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > I have not set any environment variable.
> >
> > But I do have Firebird 3..0 installed on the client Windows machine, to
> this the
> > flamerobin connects without issues.
>
>Use Process Explorer to find out which exactly fbclient.dll is loaded.
>

I do not find fbclient.dll listed in the Task Manager of the client Windows
machine when i attempt to connect to the Firebird on the remote Ubuntu
machine using flamerobin on the Windows client machine.


>
> --
>WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] Error Loading Pluggin Engine12

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

23.06.2020 18:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> I have not set any environment variable.
> 
> But I do have Firebird 3..0 installed on the client Windows machine, to this 
> the 
> flamerobin connects without issues.

   Use Process Explorer to find out which exactly fbclient.dll is loaded.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Error Loading Pluggin Engine12

[LtColRDSChauhan rdsc1...@gmail.com [firebird-support]]

On Tue, Jun 23, 2020 at 9:12 PM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support]  wrote:

> 23.06.2020 17:35, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > connect "192.168.0.2:/home/ubuntuUser/Firebird/MYDB.FDB" user 'SYSDBA'
> password 'myPassword';
>
>I see. Normally Firebird client library cannot find plugins and don't
> try to use them.
> Is environment variable FIREBIRD set to something like "d:\Program
> Files\Firebird_3_0\"?
>

I have not set any environment variable.

But I do have Firebird 3.0 installed on the client Windows machine, to this
the flamerobin connects without issues.

>
> --
>WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] Error Loading Pluggin Engine12

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

23.06.2020 17:35, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> connect "192.168.0.2:/home/ubuntuUser/Firebird/MYDB.FDB" user 'SYSDBA' 
> password 'myPassword';

   I see. Normally Firebird client library cannot find plugins and don't try to 
use them. 
Is environment variable FIREBIRD set to something like "d:\Program 
Files\Firebird_3_0\"?

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Error Loading Pluggin Engine12

[LtColRDSChauhan rdsc1...@gmail.com [firebird-support]]

On Tue, Jun 23, 2020 at 8:27 PM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support]  wrote:

> 23.06.2020 16:08, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > Do not use embedded mode.
> >
> > I am not using embedded mode.
>
>Show connection string.
>

connect "192.168.0.2:/home/ubuntuUser/Firebird/MYDB.FDB" user 'SYSDBA'
password 'myPassword';

>
> --
>WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] Error Loading Pluggin Engine12

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

23.06.2020 16:08, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
>     Do not use embedded mode.
> 
> I am not using embedded mode.

   Show connection string.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Error Loading Pluggin Engine12

[LtColRDSChauhan rdsc1...@gmail.com [firebird-support]]

On Tue, 23 Jun 2020, 7:37 pm Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support],  wrote:

> 23.06.2020 14:46, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > But when I try to connect using Flamerobin, i get the message:
> >
> > Error loading plugin Engine12
> > Module d:\Program Files\Firebird_3_0\plugins/Engine12 exists but can
> > be loaded
> > unknown Win32 error 193
>
>Flame Robin is 32 bit executable. d:\Program
> Files\Firebird_3_0\plugins/Engine12.dll
> most likely 64 bits library. Result is unavoidable.
>Do not use embedded mode.
>

I am not using embedded mode.

>
> --
>WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] Error Loading Pluggin Engine12

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

23.06.2020 14:46, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> But when I try to connect using Flamerobin, i get the message:
> 
> Error loading plugin Engine12
> Module d:\Program Files\Firebird_3_0\plugins/Engine12 exists but can
> be loaded
> unknown Win32 error 193

   Flame Robin is 32 bit executable. d:\Program 
Files\Firebird_3_0\plugins/Engine12.dll 
most likely 64 bits library. Result is unavoidable.
   Do not use embedded mode.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird running many databases

[Louis Kleiman lklei...@sstms.com [firebird-support]]

I'm jumping in late on this one, but I'm wondering if you could implement a
single database that all users share but they are restricted to seeing only
their own data.  I know it isn't the question you asked, but I believe that
many rows are more easily handled than many databases.

I'm glad you got your problem fixed, but I fear it is only a matter of time
before this issue pops up again.

Good luck!

Louis Kleiman


On Wed, May 6, 2020 at 7:34 PM Tony Christiansen t...@adegroup.com.au
[firebird-support]  wrote:

> Thank you for spelling that out - my deductive powers are weak. ;(
>
> Best regards
>
> On 6/05/2020 8:04 pm, Dimitry Sibiryakov s...@ibphoenix.com
> [firebird-support] wrote:
> > 06.05.2020 12:01, Tony Christiansen t...@adegroup.com.au
> [firebird-support] wrote:
> >> It just shows
> >>
> >> Firebird SQL Server (32 bit)
> >> - Firebird Server - DefaultInstance
> >>
> >> No mention of the mode that I can see.
> > You should also read documentation about differences between the
> modes. Classic server
> > runs process per attachment.
> >
>
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] SQL Error 303

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

27.05.2020 13:29, 'Olaf Kluge' olaf.kl...@satron.de [firebird-support] wrote:
> what function can I take instead of the isc_expand_dpb?

   There is no replacement for this function. You must use the same allocation 
function 
that was used for original DPB which depends on the host language.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] SQL Error 303

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

The Firebird-support mailing list has moved from Yahoo Groups to Google 
Groups, https://groups.google.com/d/forum/firebird-support (or subscribe 
by emailing to firebird-support+subscr...@googlegroups.com and confirm 
by replying to the confirmation request). Could you please subscribe to 
the list on Google Groups and repost your question to that list?

Mark

On 2020-05-27 11:56, 'Check_Mail' check_m...@satron.de 
[firebird-support] wrote:
> Hello,
> 
> we have some problems since migration VC++ 2005 to VC++ 2016. The same
> code, the same fbclient.dll but now we get the error after connect:
> 
> Dynamic SQL Error
> 
> SQL error code = -303
> 
> Implementation of text subtype 205 not located.
> 
> What could it be? The charset is ISO8859_1, Firebird 3.0 superserver,
> no UDFs.
> 
> Thank you. Best regards.
> 
> Olaf

Re: [firebird-support] SQL Error 303

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

27.05.2020 12:51, 'Check_Mail' check_m...@satron.de [firebird-support] wrote:
> The name of the function is /*isc_expand_dpb*/

   This function is deprecated since Firebird 1.0.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] How To Track Deadlocks

[DougC d...@moosemail.net [firebird-support]]

You need to move this question to mailto:firebird-supp...@googlegroups.com



See https://groups.google.com/d/forum/firebird-support



 On Wed, 13 May 2020 16:39:15 -0400 Roberto Vieweg 
jjw.roberto.fireb...@gmail.com [firebird-support] 
 wrote 


 Hi.
 
 I have a environment with 150 connections over my database.
 
 My application needs to use "Wait On Locks".
 A recent change in my application (client / server architeture) starts
 to get in some deadlocks.
 
 I found this article
 https://ib-aid.com/en/how-to-track-deadlocks-in-firebird/ but the
 massive use of the database turns impossible to motitor the FBTRACE
 output.
 
 So, there is some way to track this deadlocks using the MON$ tables
 using a query?

RE: [firebird-support] Firebird x CentOS 7

[Hugo Eyng hugoe...@msn.com [firebird-support]]

Thank you Mr. Makowski

Atenciosamente,

+ + Hugo Eyng + +


De: firebird-support@yahoogroups.com  em nome 
de Philippe Makowski pmakow...@ibphoenix.fr [firebird-support] 

Enviado: quarta-feira, 13 de maio de 2020 06:40
Para: firebird-support@yahoogroups.com 
Assunto: Re: [firebird-support] Firebird x CentOS 7

Le 11/05/2020 à 21:26, Hugo Eyng hugoe...@msn.com [firebird-support] a
écrit :
> Hello Mr. Makowski,
>
> About:
>
> "According to Fedora packaging rules, firebird service is not started
>   automatically. You need to start it, as root :
> systemctl start firebird-superserver.service
>   If you want to have firebird started at each boot, as root :
>   for SuperServer :
> systemctl enable firebird-superserver.service"
>
> How to start "classic" or "superclassic"? Is it possible? And would you use 
> one of those instead "superserver"?
>
Read the Firebird documentation for that
https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-engine.html#rnfb30-engine-modes








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++


Yahoo Groups Links

Re: [firebird-support] Firebird x CentOS 7

[Philippe Makowski pmakow...@ibphoenix.fr [firebird-support]]

Le 11/05/2020 à 21:26, Hugo Eyng hugoe...@msn.com [firebird-support] a
écrit :
> Hello Mr. Makowski,
> 
> About:
> 
> "According to Fedora packaging rules, firebird service is not started
>   automatically. You need to start it, as root :
> systemctl start firebird-superserver.service
>   If you want to have firebird started at each boot, as root :
>   for SuperServer :
> systemctl enable firebird-superserver.service"
> 
> How to start "classic" or "superclassic"? Is it possible? And would you use 
> one of those instead "superserver"?
> 
Read the Firebird documentation for that
https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-engine.html#rnfb30-engine-modes








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

RE: [firebird-support] Firebird x CentOS 7

[Hugo Eyng hugoe...@msn.com [firebird-support]]

Hello Mr. Makowski,

About:

"According to Fedora packaging rules, firebird service is not started
  automatically. You need to start it, as root :
systemctl start firebird-superserver.service
  If you want to have firebird started at each boot, as root :
  for SuperServer :
systemctl enable firebird-superserver.service"

How to start "classic" or "superclassic"? Is it possible? And would you use one 
of those instead "superserver"?





Atenciosamente,

+ + Hugo Eyng + +


De: firebird-support@yahoogroups.com  em nome 
de Philippe Makowski pmakow...@ibphoenix.fr [firebird-support] 

Enviado: sábado, 9 de maio de 2020 12:18
Para: firebird-support@yahoogroups.com 
Assunto: Re: [firebird-support] Firebird x CentOS 7

Hugo Eyng hugoe...@msn.com [firebird-support] a écrit le 08/05/2020 à
21:07 :
> Dear Friends,
>
> Where can I find a good tutorial to learn how to install FB 2.5.9 ( or 
> higher) in CentOS 7?
>
> If anyone already installed and used FB in this SO: what the best option: 
> 1-superserver, 2-classic, 3-superclassic?
>
you can install Firebird 3 from this repository :

https://copr.fedorainfracloud.org/coprs/makowski/firebird/

Differences between upstream and the Fedora package
===

* In /usr/bin you have isql-fb for Firebird isql.
  We can't name it isql to avoid conflict with isql from UNIX-ODBC.
  In /usr/bin you have also gstat-fb for Firebird gstat.
  We can't name it gstat to avoid conflict with gstat from Ganglia-gmond.

* By default, Firebird is set as superserver mode.
  Please read the Firebird doc if you want to change the mode.
  To help you, you have systemd units in /usr/share/firebird/misc.

* According to Fedora packaging rules, firebird service is not started
  automatically. You need to start it, as root :
  for SuperServer :
systemctl start firebird-superserver.service
  If you want to have firebird started at each boot, as root :
  for SuperServer :
systemctl enable firebird-superserver.service

--
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++


Yahoo Groups Links

Re: [firebird-support] Firebird x CentOS 7

[Philippe Makowski pmakow...@ibphoenix.fr [firebird-support]]

Hugo Eyng hugoe...@msn.com [firebird-support] a écrit le 08/05/2020 à
21:07 :
> Dear Friends,
> 
> Where can I find a good tutorial to learn how to install FB 2.5.9 ( or 
> higher) in CentOS 7?
> 
> If anyone already installed and used FB in this SO: what the best option: 
> 1-superserver, 2-classic, 3-superclassic?
> 
you can install Firebird 3 from this repository :

https://copr.fedorainfracloud.org/coprs/makowski/firebird/

Differences between upstream and the Fedora package
===

* In /usr/bin you have isql-fb for Firebird isql.
  We can't name it isql to avoid conflict with isql from UNIX-ODBC.
  In /usr/bin you have also gstat-fb for Firebird gstat.
  We can't name it gstat to avoid conflict with gstat from Ganglia-gmond.

* By default, Firebird is set as superserver mode.
  Please read the Firebird doc if you want to change the mode.
  To help you, you have systemd units in /usr/share/firebird/misc.

* According to Fedora packaging rules, firebird service is not started
  automatically. You need to start it, as root :
  for SuperServer :
systemctl start firebird-superserver.service
  If you want to have firebird started at each boot, as root :
  for SuperServer :
systemctl enable firebird-superserver.service

-- 
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird running many databases

[Tony Christiansen t...@adegroup.com.au [firebird-support]]

Thank you for spelling that out - my deductive powers are weak. ;(

Best regards

On 6/05/2020 8:04 pm, Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] wrote:
> 06.05.2020 12:01, Tony Christiansen t...@adegroup.com.au [firebird-support] 
> wrote:
>> It just shows
>>
>> Firebird SQL Server (32 bit)
>> - Firebird Server - DefaultInstance
>>
>> No mention of the mode that I can see.
> You should also read documentation about differences between the modes. 
> Classic server
> runs process per attachment.
>







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird running many databases

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

06.05.2020 12:01, Tony Christiansen t...@adegroup.com.au [firebird-support] 
wrote:
> It just shows
> 
> Firebird SQL Server (32 bit)
> - Firebird Server - DefaultInstance
> 
> No mention of the mode that I can see.

   You should also read documentation about differences between the modes. 
Classic server 
runs process per attachment.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird running many databases

[Tony Christiansen t...@adegroup.com.au [firebird-support]]

It just shows

Firebird SQL Server (32 bit)
- Firebird Server - DefaultInstance

No mention of the mode that I can see.

On 6/05/2020 7:28 pm, Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] wrote:
> 06.05.2020 01:41, Tony Christiansen t...@adegroup.com.au [firebird-support] 
> wrote:
>> Is there a way to check what mode FB v3.0 server is running in?
> Windows Task Manager.
>







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird running many databases

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

06.05.2020 01:41, Tony Christiansen t...@adegroup.com.au [firebird-support] 
wrote:
> Is there a way to check what mode FB v3.0 server is running in?

   Windows Task Manager.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird running many databases

[Tony Christiansen t...@adegroup.com.au [firebird-support]]

Thanks Dimitry

We have changed to 64-bit FB and it has significantly reduced the errors 
so I suspect it was RAM etc resource related.

I will check firebird.log for more info.

Is there a way to check what mode FB v3.0 server is running in? Is the 
only way to look at servermode in firebird.conf?

Many thanks

 >>My application (Delphi using IBX) has started randomly raising 
exceptions "Error writing data to the connection" when the user queries 
their database.


On 5/05/2020 9:22 pm, Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] wrote:
>   FB server version be better than the other in this scenario?
> Yes. Recent versions used to be better than old ones. Classic server may 
> workaround
> some problems while they are not fixed but still you must detect and 
> investigate them.
>







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird running many databases

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.05.2020 06:57, Tony Christiansen t...@adegroup.com.au [firebird-support] 
wrote:
> My application (Delphi using IBX) has started randomly raising
> exceptions "Error writing data to the connection" when the user queries
> their database.

   What is in server's firebird.log at this timestamp?

> Would the number of databases being accessed cause load issues for FB?

   Yes. Each database uses own page and metadata cache.

> Would one FB server version be better than the other in this scenario?

   Yes. Recent versions used to be better than old ones. Classic server may 
workaround 
some problems while they are not fixed but still you must detect and 
investigate them.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

RE: [firebird-support] Re: IMPORTANT MESSGAGE: This group is moving

['Jason (PN)' ja...@jac2.co.uk [firebird-support]]

“so I guess this account is bonded to some  google email account”

When you subscribe it asks you to confirm an e-mail address you want associated 
with the group.  I hardly every use my gmail account, so linked it to the same 
e-mail as the yahoo one and getting notifications come through.

But, yes, you have to log into the group via a google login.

 

Jason Chapman

JAC2 Consultancy Limited

 

From: firebird-support@yahoogroups.com  
Sent: 05 May 2020 02:47
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: IMPORTANT MESSGAGE: This group is moving

 

  

I've never used Google Groups, so I guess this account is bonded to some 
google email account and they want me to use that one. I'll check when I 
have some spare time.

Maybe it's time to give a new spin to some netscape.com email account ?

Pablo
> 
> I tried to use the new google group and have it send you an invite to 
> join the group. What Google responded with was:
> 
> Some email addresses cannot be added to this group because their
> accounts are disabled or are blocked from Google Groups.
> 
> So Google does not like your email address for some reason.
> 
> Doug C.





[Non-text portions of this message have been removed]

Re: [firebird-support] Re: IMPORTANT MESSGAGE: This group is moving

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 05-05-2020 02:25, DougC d...@moosemail.net [firebird-support] wrote:
> I tried to use the new google group and have it send you an invite to 
> join the group. What Google responded with was:
> 
> Some email addresses cannot be added to this group because their
> accounts are disabled or are blocked from Google Groups.
> 
> So Google does not like your email address for some reason.

According to 
https://answers.yahoo.com/question/index?qid=20131030040143AACtioj:

"""
Unfortunately, the issue is on your friends side. She has disabled the 
option to allow Moderators or Groups to 'Invite' her to a group. She 
will need to go into her email settings and change it to allow it again.
"""

In other words, if this emailaddress is associated with a Google 
account, then on groups.google.com under My settings (first icon 
top-right) > My global settings under "Add/Invite settings" the option 
"Allow group managers to invite me to their groups" is disabled.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] Re: IMPORTANT MESSGAGE: This group is moving

[DougC d...@moosemail.net [firebird-support]]

Pablo-

I tried to use the new google group and have it send you an invite to join the 
group. What Google responded with was:
Some email addresses cannot be added to this group because their accounts are 
disabled or are blocked from Google Groups.




So Google does not like your email address for some reason.

Doug C.

 On Mon, 04 May 2020 18:22:49 -0400 pablo sanchez 
mailto:pab...@adinet.com.uy [firebird-support] 
 wrote 


 I sent an email to mailto:firebird-support+subscr...@googlegroups.com :
 
 /Quote
 From - Mon May 04 19:15:56 2020
 X-Mozilla-Status: 0001
 X-Mozilla-Status2: 0080
 X-Mozilla-Keys: 
 
 To: mailto:firebird-support+subscr...@googlegroups.com
 From: =?UTF-8?Q?Pablo_S=c3=a1nchez?= 
 Subject: Subscribe
 Message-ID: mailto:-83d1-5846-68a2-8f4f48b6a...@adinet.com.uy>
 Date: Mon, 4 May 2020 19:15:55 -0300
 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.7.0
 MIME-Version: 1.0
 Content-Type: text/plain; charset=utf-8; format=flowed
 Content-Transfer-Encoding: 7bit
 Content-Language: en-US
 
 Subscribe
 
 /UnQuote
 
 And I got :
 
 Address not found
 Your message wasn't delivered to 
 mailto:firebird-support+subscr...@googlegroups.com because the address 
couldn't 
 be found, or is unable to receive mail.
 
 Cheers...
 
 Pablo
 
 > 
 > You don't need a Google account to join. Email to
 > mailto:firebird-support+subscr...@googlegroups.com and confirm the join 
 > request
 > by **replying** to the join request.
 > 
 > But yes, if your email address is associated with a google account, then
 > Google will default to your gmail address, even if you subscribed from a
 > different address. To fix this you need to go to
 > https://groups.google.com/forum/#!myforums, find the group, click
 > **Edit** after your name, and change "Email used for membership" to your
 > preferred address.
 > 
 > Mark
 > -- 
 > Mark Rotteveel
 > 
 > 
 >
 

Re: [firebird-support] Next attachment ID

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 2020-05-04 10:34, Karol Bieniaszewski liviusliv...@poczta.onet.pl 
[firebird-support] wrote:
> Hi
> 
> How can i read Next Attachement ID?
> 
> I know that i can read it by gstat -h but how to read it from
> connection?
> 
> Is there something simple like for OAT – read from MON$DATABASE or
> API isc_transaction_info?
> 
> Regards,
> 
> Karol Bieniaszewski

Hi Karol, could you repost to firebird-supp...@googlegroups.com?

Mark

Re: [firebird-support] IMPORTANT MESSGAGE: This group is moving

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 02-05-2020 11:38, Lester Caine les...@lsces.uk [firebird-support] wrote:
> On 02/05/2020 00:29, Helen Borrie hele...@tpg.com.au [firebird-support]
> wrote:
>> Unfortunately we cannot migrate the current Yahoo! subscribers, and you will
>> need to resubscribe yourself, in one of two ways:
> 
> The other problem with pigging Google is their drive to make us use a
> Gmail account. They had removed my own email address and given me a
> @gmail.com one which is what they have just tried to resubscribe me with
>  it IS possible to retain a real email address, but personally I was
> trying to kill of using Google AT ALL because of the crap they keep
> pushing. SO if things don't improve I will be simply closing my google
> account completely!

You don't need a Google account to join. Email to 
firebird-support+subscr...@googlegroups.com and confirm the join request 
by **replying** to the join request.

But yes, if your email address is associated with a google account, then 
Google will default to your gmail address, even if you subscribed from a 
different address. To fix this you need to go to 
https://groups.google.com/forum/#!myforums, find the group, click 
**Edit** after your name, and change "Email used for membership" to your 
preferred address.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] IMPORTANT MESSGAGE: This group is moving

[Lester Caine les...@lsces.uk [firebird-support]]

On 02/05/2020 00:29, Helen Borrie hele...@tpg.com.au [firebird-support] 
wrote:
> Unfortunately we cannot migrate the current Yahoo! subscribers, and you will
> need to resubscribe yourself, in one of two ways:

The other problem with pigging Google is their drive to make us use a 
Gmail account. They had removed my own email address and given me a 
@gmail.com one which is what they have just tried to resubscribe me with 
 it IS possible to retain a real email address, but personally I was 
trying to kill of using Google AT ALL because of the crap they keep 
pushing. SO if things don't improve I will be simply closing my google 
account completely!

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.uk/wiki/Contact
L.S.Caine Electronic Services - https://lsces.uk
Model Engineers Digital Workshop - https://medw.uk
Rainbow Digital Media - https://rainbowdigitalmedia.uk

Re: [firebird-support] SQL slower after N executions?

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

OK, so the last change was successful: The +0 as suggested by Set works. 
The query now uses the faster query plan through the entire batch (at 
least it still does after 1769 chunks.

Many thanks for all your input! I still think it would be interesting 
with some theories about why the engine behaves like this, perhaps from 
the dev team...?

Mvh,
Kjell

Den 2020-05-01 kl. 09:53, skrev Kjell Rilbe 
kjell.ri...@marknadsinformation.se [firebird-support]:
>
> Well, the changed subselect didn't do the trick, but I think it speeds
> up the query slightly, overall.
>
> Now, it's this query that's causing problems:
>
> insert into "TmpFKExportUhant" ("ECO_ID", "Bärartyp")
> select FtgOmsar."Uppgiftshanterare", 'FöretagOmsättningsår' "Bärartyp"
> from "Företag" F
> inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
> inner join "FöretagOmsättningsår" FtgOmsar on FtgOmsar."Företag" =
> F."ECO_ID" + 0
> inner join "År" Ar on Ar."ECO_ID" = FtgOmsar."Omsättningsår" + 0
> where not exists (
>     select 1
>     from "FöretagOmsättningsår" FtgOmsar2
>     inner join "År" Ar2 on Ar2."ECO_ID" = FtgOmsar2.."Omsättningsår"
>     where FtgOmsar2."Företag" = F."ECO_ID"
>   and Ar2."Årtal" > Ar."Årtal"
>   );
>
> The "breaking point" has now moved to 361 executions. Before that point,
> the "fast" execution plan looks like this (both styles):
>
> PLAN JOIN (
>   L NATURAL,
>   F INDEX ("IX_PK_Företag"),
>   FTGOMSAR INDEX ("IX_FöretagOmsättningsåDBN"),
>   AR INDEX ("IX_PK_År")
> )
>
> Select Expression
>     -> Nested Loop Join (inner)
>     -> Filter
>     -> Table "FöretagOmsättningsår" as "FTGOMSAR2" Access By ID
>     -> Bitmap
>     -> Index "IX_FöretagOmsättningsåDBN" Range Scan
> (full match)
>     -> Filter
>     -> Table "År" as "AR2" Access By ID
>     -> Bitmap
>     -> Index "IX_PK_År" Unique Scan
> Select Expression
>     -> Nested Loop Join (inner)
>     -> Table "TmpFKExportId" as "L" Full Scan
>     -> Filter
>     -> Table "Företag" as "F" Access By ID
>     -> Bitmap
>     -> Index "IX_PK_Företag" Unique Scan
>     -> Filter
>     -> Table "FöretagOmsättningsår" as "FTGOMSAR" Access By ID
>     -> Bitmap
>     -> Index "IX_FöretagOmsättningsåDBN" Range Scan
> (full match)
>     -> Filter
>     -> Table "År" as "AR" Access By ID
>     -> Bitmap
>     -> Index "IX_PK_År" Unique Scan
>
> After the slowdown, the "bad" query plan looks like this:
>
> PLAN JOIN (
>   L NATURAL,
>   F INDEX (IX_PK_Företag),
>   FTGOMSAR INDEX (IX_FöretagOmsättningsåDBN),
>   AR INDEX (IX_PK_År)
> )
>
> Select Expression
>     -> Nested Loop Join (inner)
>     -> Filter
>     -> Table "FöretagOmsättningsår" as "FTGOMSAR2" Access By ID
>     -> Bitmap
>     -> Index "IX_FöretagOmsättningsåDBN" Range Scan
> (full match)
>     -> Filter
>     -> Table "År" as "AR2" Access By ID
>     -> Bitmap
>     -> Index "IX_PK_År" Unique Scan
> Select Expression
>     -> Nested Loop Join (inner)
>     -> Table "År" as "AR" Full Scan
>     -> Filter
>     -> Table "FöretagOmsättningsår" as "FTGOMSAR" Access By ID
>     -> Bitmap
>     -> Index "IX_FöretagOmsättningså9OF" Range Scan
> (full match)
>     -> Filter
>     -> Table "TmpFKExportId" as "L" Access By ID
>     -> Bitmap
>     -> Index "PK_TmpFKExportId" Unique Scan
>     -> Filter
>     -> Table "Företag" as "F" Access By ID
>     -> Bitmap
>     -> Index "IX_PK_Företag" Unique Scan
>
> It's worth noting that the old-style query plans are identical, but the
> new-style ones do have a difference, which is probably causing the 
> problem.
>
> I am trying now with the +0 that Set suggested.
>
> But why does Firebird cosistently change it's execution strategy for a
> query that's being executed for the Nth time without change and on
> essentially unmodified data? During these batches, the tables "År" and
> "FöretagOmsättningår" are never changed in any way.. The table "Företag"
> may be changed in a few records, but not in the columns or indices used
> in the query. The table "TmpFKExportId" will have a new set of 250 id:s
> for each execution of the query, but its index selectivity would be
> constant (1/250). So, as far as I can see, there's absolutely no reason
> to be found in the actual data. It must be something else: cache,
> workload, garbage collector...?
>
> But during the batch, FBMonitor doesn't show any change in the garbage
> collector's behavior at the time of slowdown/change of query strategy.
>
> The only thing I can see in FBMonitor's graphs is that about 35 minutes
> before the slowdown, the I/O activity graph shows an increase in cache
> hits, but no apparent chan

Re: [firebird-support] new Google groups

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 2020-05-01 02:20, Hamish Moffatt ham...@risingsoftware.com 
[firebird-support] wrote:
> The firebirdsql.org site lists new Google groups to replace the yahoo
> firebird-support and firebird-general lists, but the links don't work -
> I get permission denied errors trying to visit them.
> 
> Are these new lists set up and ready to go?

I believe that right now those groups haven't been configured with the 
right (public) visibility yet.

Mark

Re: [firebird-support] FB1 to FB3

[Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]]

Sorry Carlos - I read that wrong.  Thought you were asking if the script could 
be run with isql.

Cheers,
Kevin



 

> On Apr 30, 2020, at 8:04 AM, 'Carlos H. Cantu' lis...@warmboot.com.br 
> [firebird-support]  wrote:
> 
> Step 1 is better if you are going from dialect 1 to 3, mostly due to
> the difference in the numerics internal storage.
> 
> I see no problem with any of the approaches.
> 
> I would add that, imho, step 4 in process 2 is not really necessary,
> unless you want to reset the metadata versions count of the objects
> from 1 to 0.
> 
> Also, about step 3, you can prepare a script with "create or alter"
> statements of your procedures, triggers, etc. and run it using any
> tool or even isql.
> 
> []s
> Carlos
> Migration Guide to FB 3
> http://www.firebirdnews.org/migration-guide-to-firebird-3/ 
> 
> 
> KSKSRScfs> Greetings!
> 
> KSKSRScfs> Process 1:
> KSKSRScfs> Via a script, I have successfully exported and migrated
> KSKSRScfs> all data and objects from a FB1 database to FB3.
> KSKSRScfs> Creating the objects originally had just a few errors but
> KSKSRScfs> those have been fixed and it now goes across cleanly, no errors.
> KSKSRScfs> This process has been the one most widely recommended.
> 
> KSKSRScfs> Process 2:
> KSKSRScfs> With the corrected database that goes cleanly to FB3, I tried the 
> following:
> KSKSRScfs> 1. Backup the database with FB1.
> KSKSRScfs> 2. Restore the database with FB3.
> KSKSRScfs> 3. Executed two of IB Expert’s functions: a) Recompile all
> KSKSRScfs> Procedures and b) Recompile all Triggers. (No errors)
> KSKSRScfs> 4. Performed a backup / restore with no errors.
> 
> KSKSRScfs> My question: is Process 2 an acceptable path? The only
> KSKSRScfs> reason I ask is one of my customers has many millions of
> KSKSRScfs> records and I believe Process 2 will save me a weekend of
> KSKSRScfs> work. (My next step is to benchmark how long Process 1
> KSKSRScfs> will take for this customer’s database).
> 
> KSKSRScfs> Many Thanks!
> 
> KSKSRScfs> Kevin
> 
> 
> 



[Non-text portions of this message have been removed]

Re: [firebird-support] Timestamp in different regions

[Gregor Kobler gregorkob...@yahoo.com [firebird-support]]

Of course your software uses the client-library. Normaly FireDAV uses by 
default fbclient.dll. Your software will look at the windows path

I copy the fbclient.dll from firebird install folder to my client program 
folder. But be aware to use the right version 32/64Bit! the 32 bit version you 
will find at C:\Program Files\Firebird\Firebird_3_0\WOW64, the 64 Bit at 
C:\Program Files\Firebird\Firebird_3_0

also copy the two following dll's"msvcr100.dll" and "msvcp100.dll" do your 
program folder. This are also an option, that a client PC not has to install 
any firebird software. Your program will run without firebird installed (but 
just at client-PC's)!

Add a TFDPhysFBDriverLink component to your Delphi project, and define the 
propertie VendorLib to e.g. "C:\Temp\myprojectpath\fbclient.dll". What ever you 
whant, set the path where the three dll's are!

Gregor

Sent from Yahoo Mail. Get the app 

On Thursday, April 30, 2020, 6:52:20 PM GMT+2, 'Zoran' zoran...@gmail.com 
[firebird-support]  wrote:  
 
     
Hi Gregor

Thank you for the answer.

I’m using FireDAC components. FB version is 3.0.5. My middle-ware server 
program and FB engine are on VPS located in US. I’m developing client app also 
in US. All works ok since both programs are in the same region.

I have VM with Win 10 and region set to Europe. I’ve installed FB and server 
middle-ware in this VM as well. When I execute client app connecting to US 
server, I get the error. When I execute client app connecting to the local 
server (which on the same VM machine) all works ok.

I’m not using client-library fbclient.dll or GDS32.dll. This is multi-user app, 
some users are in US some are in Europe.

Error happens as soon as I execute ‘qry.Open;’ statement. Karol suggested to 
debug the code and I will. But this will go to FireDAC code which is rather 
complicated. That’s why I’ve asked here if someone experienced similar problem.

Regards

Zoran

From: firebird-support@yahoogroups.com  
Sent: Thursday, April 30, 2020 11:35 AM
To: 'Zoran' zoran...@gmail.com [firebird-support] 

Subject: Re: [firebird-support] Timestamp in different regions

Hello Zoran

Witch Component do you useing in Delphi FireDAC?

Are you shure, that that your clients uses the right client-library 
fbclient.dll or GDS32.dll? Means FB 3.0.5 should use fbclient from V3.0.5

What FB Version do you use?

Best Regards
Gregor

Sent from Yahoo Mail. Get the app

On Thursday, April 30, 2020, 05:30:22 PM GMT+2, 'Zoran' zoran...@gmail.com 
[firebird-support]  wrote: 

Thank you, Karol.

Probably not FB message. I guess it’s coming from Delphi. It happens right 
after I execute ‘qry.Open;’ statement..

What I was hopping for is if someone with Delphi background can shed some light 
on Delphi handling this situation.

From: firebird-support@yahoogroups.com  
Sent: Thursday, April 30, 2020 11:09 AM
To: firebird-support@yahoogroups.com
Subject: ODP: [firebird-support] Timestamp in different regions

I do not suppose that this is Firebird message.

This looks like client program message. 

regards,

Karol Bieniaszewski

Firebird 3.0.5, Delphi 10.3.3

In a table I have TIMESTAMP column. If I read that table from the client in the 
same Region as server all is ok. If I read the same table where client is in 
the different region than server, I get error message 'Could not parse SQL 
TimeStamp string'. 

In another words if server is in US and client is in US all is ok. If server is 
in Europe and client is in Europe, all is ok. But, if server is in US and 
client is in Europe (and vice-versa) I get this error.

Does anyone experience this, or am I missing something here?_,

Thank you

Zoran

[Non-text portions of this message have been removed]


  #yiv5410137613 #yiv5410137613 -- #yiv5410137613ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5410137613 
#yiv5410137613ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5410137613 
#yiv5410137613ygrp-mkp #yiv5410137613hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv5410137613 #yiv5410137613ygrp-mkp #yiv5410137613ads 
{margin-bottom:10px;}#yiv5410137613 #yiv5410137613ygrp-mkp .yiv5410137613ad 
{padding:0 0;}#yiv5410137613 #yiv5410137613ygrp-mkp .yiv5410137613ad p 
{margin:0;}#yiv5410137613 #yiv5410137613ygrp-mkp .yiv5410137613ad a 
{color:#ff;text-decoration:none;}#yiv5410137613 #yiv5410137613ygrp-sponsor 
#yiv5410137613ygrp-lc {font-family:Arial;}#yiv5410137613 
#yiv5410137613ygrp-sponsor #yiv5410137613ygrp-lc #yiv5410137613hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5410137613 
#yiv5410137613ygrp-sponsor #yiv5410137613ygrp-lc .yiv5410137613ad 
{margin-bottom:10px;padding:0 0;}#yiv5410137613 #yiv5410137613actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5410137613 
#yiv5410137613activity 
{background-color:#e0ecee;float:left;font-family:V

RE: [firebird-support] Timestamp in different regions

['Zoran' zoran...@gmail.com [firebird-support]]

Hi Gregor

 

Thank you for the answer.

 

I’m using FireDAC components. FB version is 3.0.5. My middle-ware server 
program and FB engine are on VPS located in US. I’m developing client app also 
in US. All works ok since both programs are in the same region.

 

I have VM with Win 10 and region set to Europe. I’ve installed FB and server 
middle-ware in this VM as well. When I execute client app connecting to US 
server, I get the error. When I execute client app connecting to the local 
server (which on the same VM machine) all works ok.

 

I’m not using client-library fbclient.dll or GDS32.dll. This is multi-user app, 
some users are in US some are in Europe.

 

Error happens as soon as I execute ‘qry.Open;’ statement. Karol suggested to 
debug the code and I will. But this will go to FireDAC code which is rather 
complicated. That’s why I’ve asked here if someone experienced similar problem.

 

Regards

Zoran

 

 

From: firebird-support@yahoogroups.com  
Sent: Thursday, April 30, 2020 11:35 AM
To: 'Zoran' zoran...@gmail.com [firebird-support] 

Subject: Re: [firebird-support] Timestamp in different regions

 

  

Hello Zoran

Witch Component do you useing in Delphi FireDAC?

Are you shure, that that your clients uses the right client-library 
fbclient.dll or GDS32.dll? Means FB 3.0.5 should use fbclient from V3.0.5

What FB Version do you use?

Best Regards
Gregor



Sent from Yahoo Mail. Get the app



On Thursday, April 30, 2020, 05:30:22 PM GMT+2, 'Zoran' zoran...@gmail.com 
[firebird-support]  wrote: 

 

 

 

Thank you, Karol.

 

Probably not FB message. I guess it’s coming from Delphi. It happens right 
after I execute ‘qry.Open;’ statement..

What I was hopping for is if someone with Delphi background can shed some light 
on Delphi handling this situation.

 

 

From: firebird-support@yahoogroups.com  
Sent: Thursday, April 30, 2020 11:09 AM
To: firebird-support@yahoogroups.com
Subject: ODP: [firebird-support] Timestamp in different regions

 

  

I do not suppose that this is Firebird message.

This looks like client program message. 

 

regards,

Karol Bieniaszewski

 

 

Firebird 3.0.5, Delphi 10.3.3

 

In a table I have TIMESTAMP column. If I read that table from the client in the 
same Region as server all is ok. If I read the same table where client is in 
the different region than server, I get error message 'Could not parse SQL 
TimeStamp string'. 

 

In another words if server is in US and client is in US all is ok. If server is 
in Europe and client is in Europe, all is ok. But, if server is in US and 
client is in Europe (and vice-versa) I get this error.

 

Does anyone experience this, or am I missing something here?_,

 

Thank you

Zoran





[Non-text portions of this message have been removed]

Re: [firebird-support] FB1 to FB3

[Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]]

Great - thanks Mark.  I only need FR just for that, simple queries and the 
occasional update/delete sql.


 

> On Apr 30, 2020, at 9:09 AM, Mark Rotteveel m...@lawinegevaar.nl 
> [firebird-support]  wrote:
> 
> On 2020-04-30 17:42, Kevin Stanton kevin.stan...@rdb-solutions.com 
>  
> [firebird-support] wrote:
> > I always tend to do back / restores not only in this migration but on
> > a regular basis. I’m maybe a little on the paranoid side. :)
> > I have noticed some extra lines in the restore log for FB3 (this is
> > true even on a completely new FB3 database):
> > 
> > gbak:fixing views dbkey length
> > gbak:updating ownership of packages, procedures and tables
> > gbak:adding missing privileges
> > gbak:fixing system generators
> > gbak:finishing, closing, and going home
> > gbak:adjusting the ONLINE and FORCED WRITES flags
> > 
> 
> Those are just steps that gbak will apply, even if there is 'nothing to 
> fix'.
> 
> > 
> > The script is very easily generated out of IB Expert. I cannot praise
> > this tool enough.
> > 
> > I haven’t tried the script using isql but I would be surprised if it
> > didn’t work. I will give it a shot possibly over this coming weekend.
> > I’m slammed at the moment.
> > 
> > I also use FlameRobin for FB1. Not sure if that is compatible with
> > FB3? There were some concerns in previous postings.
> 
> FlameRobin works with Firebird 3, but it doesn't support the new boolean 
> datatype, and it has no support for packages and PSQL function, which 
> might incorrectly show procedures from packages, or functions. In 
> addition, user management should now be done through SQL, so the user 
> management options in FlameRobin will still work, but they will only 
> work with the first (default) UserManager. There might be some more 
> issues, but for general query work it will work fine.
> 
> Mark
> 
> 



[Non-text portions of this message have been removed]

Re: [firebird-support] FB1 to FB3

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 2020-04-30 17:42, Kevin Stanton kevin.stan...@rdb-solutions.com 
[firebird-support] wrote:
> I always tend to do back / restores not only in this migration but on
> a regular basis.  I’m maybe a little on the paranoid side.  :)
> I have noticed some extra lines in the restore log for FB3 (this is
> true even on a completely new FB3 database):
> 
> gbak:fixing views dbkey length
> gbak:updating ownership of packages, procedures and tables
> gbak:adding missing privileges
> gbak:fixing system generators
> gbak:finishing, closing, and going home
> gbak:adjusting the ONLINE and FORCED WRITES flags
> 

Those are just steps that gbak will apply, even if there is 'nothing to 
fix'.

> 
> The script is very easily generated out of IB Expert.  I cannot praise
> this tool enough.
> 
> I haven’t tried the script using isql but I would be surprised if it
> didn’t work.  I will give it a shot possibly over this coming weekend.
>  I’m slammed at the moment.
> 
> I also use FlameRobin for FB1.  Not sure if that is compatible with
> FB3?  There were some concerns in previous postings.

FlameRobin works with Firebird 3, but it doesn't support the new boolean 
datatype, and it has no support for packages and PSQL function, which 
might incorrectly show procedures from packages, or functions. In 
addition, user management should now be done through SQL, so the user 
management options in FlameRobin will still work, but they will only 
work with the first (default) UserManager. There might be some more 
issues, but for general query work it will work fine.

Mark

Re: [firebird-support] FB1 to FB3

[Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]]

I always tend to do back / restores not only in this migration but on a regular 
basis.  I’m maybe a little on the paranoid side.  :)
I have noticed some extra lines in the restore log for FB3 (this is true even 
on a completely new FB3 database):

gbak:fixing views dbkey length
gbak:updating ownership of packages, procedures and tables
gbak:adding missing privileges
gbak:fixing system generators
gbak:finishing, closing, and going home
gbak:adjusting the ONLINE and FORCED WRITES flags






The script is very easily generated out of IB Expert.  I cannot praise this 
tool enough.

I haven’t tried the script using isql but I would be surprised if it didn’t 
work.  I will give it a shot possibly over this coming weekend.  I’m slammed at 
the moment.

I also use FlameRobin for FB1.  Not sure if that is compatible with FB3?  There 
were some concerns in previous postings.


Cheers,
Kevin



 

> On Apr 30, 2020, at 8:04 AM, 'Carlos H. Cantu' lis...@warmboot.com.br 
> [firebird-support]  wrote:
> 
> Step 1 is better if you are going from dialect 1 to 3, mostly due to
> the difference in the numerics internal storage.
> 
> I see no problem with any of the approaches.
> 
> I would add that, imho, step 4 in process 2 is not really necessary,
> unless you want to reset the metadata versions count of the objects
> from 1 to 0.
> 
> Also, about step 3, you can prepare a script with "create or alter"
> statements of your procedures, triggers, etc. and run it using any
> tool or even isql.
> 
> []s
> Carlos
> Migration Guide to FB 3
> http://www.firebirdnews.org/migration-guide-to-firebird-3/ 
> 
> 
> KSKSRScfs> Greetings!
> 
> KSKSRScfs> Process 1:
> KSKSRScfs> Via a script, I have successfully exported and migrated
> KSKSRScfs> all data and objects from a FB1 database to FB3.
> KSKSRScfs> Creating the objects originally had just a few errors but
> KSKSRScfs> those have been fixed and it now goes across cleanly, no errors.
> KSKSRScfs> This process has been the one most widely recommended.
> 
> KSKSRScfs> Process 2:
> KSKSRScfs> With the corrected database that goes cleanly to FB3, I tried the 
> following:
> KSKSRScfs> 1. Backup the database with FB1.
> KSKSRScfs> 2. Restore the database with FB3.
> KSKSRScfs> 3. Executed two of IB Expert’s functions: a) Recompile all
> KSKSRScfs> Procedures and b) Recompile all Triggers. (No errors)
> KSKSRScfs> 4. Performed a backup / restore with no errors.
> 
> KSKSRScfs> My question: is Process 2 an acceptable path? The only
> KSKSRScfs> reason I ask is one of my customers has many millions of
> KSKSRScfs> records and I believe Process 2 will save me a weekend of
> KSKSRScfs> work. (My next step is to benchmark how long Process 1
> KSKSRScfs> will take for this customer’s database).
> 
> KSKSRScfs> Many Thanks!
> 
> KSKSRScfs> Kevin
> 
> 
> 



[Non-text portions of this message have been removed]

Re: [firebird-support] Timestamp in different regions

[Gregor Kobler gregorkob...@yahoo.com [firebird-support]]

 Hello Zoran

Witch Component do you useing in Delphi FireDAC?

Are you shure, that that your clients uses the right client-library 
fbclient.dll or GDS32.dll? Means FB 3.0.5 should use fbclient from V3.0.5

What FB Version do you use?

Best Regards
Gregor



Sent from Yahoo Mail. Get the app


 On Thursday, April 30, 2020, 05:30:22 PM GMT+2, 'Zoran' 
zoran...@gmail..com [firebird-support]  
wrote:  
 
     


Thank you, Karol.

  

Probably not FB message. I guess it’s coming from Delphi. It happens right 
after I execute ‘qry.Open;’ statement.

 

What I was hopping for is if someone with Delphi background can shed some light 
on Delphi handling this situation.

  

  

From: firebird-support@yahoogroups.com  
Sent: Thursday, April 30, 2020 11:09 AM
To: firebird-support@yahoogroups.com
Subject: ODP: [firebird-support] Timestamp in different regions

  

  

I do not suppose that this is Firebird message.

This looks like client program message. 

 

regards,

Karol Bieniaszewski

  

  

Firebird 3.0.5, Delphi 10.3.3

  

In a table I have TIMESTAMP column. If I read that table from the client in the 
same Region as server all is ok. If I read the same table where client is in 
the different region than server, I get error message 'Could not parse SQL 
TimeStamp string'. 

  

In another words if server is in US and client is in US all is ok. If server is 
in Europe and client is in Europe, all is ok. But, if server is in US and 
client is in Europe (and vice-versa) I get this error.

  

Does anyone experience this, or am I missing something here?_,

  

Thank you

Zoran


  #yiv7077494043 #yiv7077494043 -- #yiv7077494043ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7077494043 
#yiv7077494043ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7077494043 
#yiv7077494043ygrp-mkp #yiv7077494043hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv7077494043 #yiv7077494043ygrp-mkp #yiv7077494043ads 
{margin-bottom:10px;}#yiv7077494043 #yiv7077494043ygrp-mkp .yiv7077494043ad 
{padding:0 0;}#yiv7077494043 #yiv7077494043ygrp-mkp .yiv7077494043ad p 
{margin:0;}#yiv7077494043 #yiv7077494043ygrp-mkp .yiv7077494043ad a 
{color:#ff;text-decoration:none;}#yiv7077494043 #yiv7077494043ygrp-sponsor 
#yiv7077494043ygrp-lc {font-family:Arial;}#yiv7077494043 
#yiv7077494043ygrp-sponsor #yiv7077494043ygrp-lc #yiv7077494043hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7077494043 
#yiv7077494043ygrp-sponsor #yiv7077494043ygrp-lc .yiv7077494043ad 
{margin-bottom:10px;padding:0 0;}#yiv7077494043 #yiv7077494043actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7077494043 
#yiv7077494043activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7077494043
 #yiv7077494043activity span {font-weight:700;}#yiv7077494043 
#yiv7077494043activity span:first-child 
{text-transform:uppercase;}#yiv7077494043 #yiv7077494043activity span a 
{color:#5085b6;text-decoration:none;}#yiv7077494043 #yiv7077494043activity span 
span {color:#ff7900;}#yiv7077494043 #yiv7077494043activity span 
.yiv7077494043underline {text-decoration:underline;}#yiv7077494043 
.yiv7077494043attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv7077494043 .yiv7077494043attach div a 
{text-decoration:none;}#yiv7077494043 .yiv7077494043attach img 
{border:none;padding-right:5px;}#yiv7077494043 .yiv7077494043attach label 
{display:block;margin-bottom:5px;}#yiv7077494043 .yiv7077494043attach label a 
{text-decoration:none;}#yiv7077494043 blockquote {margin:0 0 0 
4px;}#yiv7077494043 .yiv7077494043bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7077494043 
.yiv7077494043bold a {text-decoration:none;}#yiv7077494043 dd.yiv7077494043last 
p a {font-family:Verdana;font-weight:700;}#yiv7077494043 dd.yiv7077494043last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7077494043 
dd.yiv7077494043last p span.yiv7077494043yshortcuts 
{margin-right:0;}#yiv7077494043 div.yiv7077494043attach-table div div a 
{text-decoration:none;}#yiv7077494043 div.yiv7077494043attach-table 
{width:400px;}#yiv7077494043 div.yiv7077494043file-title a, #yiv7077494043 
div.yiv7077494043file-title a:active, #yiv7077494043 
div.yiv7077494043file-title a:hover, #yiv7077494043 div.yiv7077494043file-title 
a:visited {text-decoration:none;}#yiv7077494043 div.yiv7077494043photo-title a, 
#yiv7077494043 div.yiv7077494043photo-title a:active, #yiv7077494043 
div.yiv7077494043photo-title a:hover, #yiv7077494043 
div.yiv7077494043photo-title a:visited {text-decoration:none;}#yiv7077494043 
div#yiv7077494043ygrp-mlmsg #yiv7077494043ygrp-msg p a 
span.yiv7077494043yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7077494043 
.yiv7077494043green {color:#628c2a;}#yiv7077494043 .yiv7077494043MsoNormal 
{margin:0 0 0 0;}#yiv7077494043 o {font-size:0;}#yiv7077494043 
#yiv

Re: [firebird-support] FB1 to FB3

[Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]]

Thankfully I moved from D1 to D3 many years ago.

So now just need to get to FB3.


Cheers,
Kevin





 

> On Apr 30, 2020, at 7:37 AM, 'Jason (PN)' ja...@jac2.co.uk [firebird-support] 
>  wrote:
> 
> Hi Kevin,
> 
> Can I ask what dialect you are going from and to?
> 
> Sorry I don’t have an opinion on P1 vs P2. Do you know why P1 is recommended 
> over P2?
> 
> As you may have guessed, I have this same thing to do 1.5.6 D1 -> ?.
> 
> Thanks,
> 
> Jason
> 
> From: firebird-support@yahoogroups.com 
>   > 
> Sent: 30 April 2020 15:23
> To: Firebird Support  >
> Subject: [firebird-support] FB1 to FB3
> 
> Greetings!
> 
> Process 1:
> Via a script, I have successfully exported and migrated all data and objects 
> from a FB1 database to FB3.
> Creating the objects originally had just a few errors but those have been 
> fixed and it now goes across cleanly, no errors. 
> This process has been the one most widely recommended.
> 
> Process 2:
> With the corrected database that goes cleanly to FB3, I tried the following:
> 1. Backup the database with FB1.
> 2. Restore the database with FB3.
> 3. Executed two of IB Expert’s functions: a) Recompile all Procedures and b) 
> Recompile all Triggers. (No errors)
> 4. Performed a backup / restore with no errors.
> 
> My question: is Process 2 an acceptable path? The only reason I ask is one of 
> my customers has many millions of records and I believe Process 2 will save 
> me a weekend of work. (My next step is to benchmark how long Process 1 will 
> take for this customer’s database).
> 
> Many Thanks!
> 
> Kevin
> 
> [Non-text portions of this message have been removed]
> 
> [Non-text portions of this message have been removed]
> 
> 
> 



[Non-text portions of this message have been removed]

Re: [firebird-support] Timestamp in different regions

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

30.04.2020 17:30, 'Zoran' zoran...@gmail.com [firebird-support] wrote:
> What I was hopping for is if someone with Delphi background can shed some 
> light on Delphi 
> handling this situation.

   Usually such situations are handled by debugging. You use debugging version 
of VCL and 
RTL, enable break on exception and look at the piece of code where the error 
has happened.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

RE: [firebird-support] Timestamp in different regions

['Zoran' zoran...@gmail.com [firebird-support]]

Thank you, Karol.

 

Probably not FB message. I guess it’s coming from Delphi. It happens right 
after I execute ‘qry.Open;’ statement.

What I was hopping for is if someone with Delphi background can shed some light 
on Delphi handling this situation.

 

 

From: firebird-support@yahoogroups.com  
Sent: Thursday, April 30, 2020 11:09 AM
To: firebird-support@yahoogroups.com
Subject: ODP: [firebird-support] Timestamp in different regions

 

  

I do not suppose that this is Firebird message.

This looks like client program message. 

 

regards,

Karol Bieniaszewski

 

 

Firebird 3.0.5, Delphi 10.3.3

 

In a table I have TIMESTAMP column. If I read that table from the client in the 
same Region as server all is ok. If I read the same table where client is in 
the different region than server, I get error message 'Could not parse SQL 
TimeStamp string'. 

 

In another words if server is in US and client is in US all is ok. If server is 
in Europe and client is in Europe, all is ok. But, if server is in US and 
client is in Europe (and vice-versa) I get this error.

 

Does anyone experience this, or am I missing something here?_,

 

Thank you

Zoran

Re: [firebird-support] FB1 to FB3

['Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]]

Step 1 is better if you are going from dialect 1 to 3, mostly due to
the difference in the numerics internal storage.

I see no problem with any of the approaches.

I would add that, imho, step 4 in process 2 is not really necessary,
unless you want to reset the metadata versions count of the objects
from 1 to 0.

Also, about step 3, you can prepare a script with "create or alter"
statements of your procedures, triggers, etc. and run it using any
tool or even isql.

[]s
Carlos
Migration Guide to FB 3
http://www.firebirdnews.org/migration-guide-to-firebird-3/


KSKSRScfs> Greetings!

KSKSRScfs> Process 1:
KSKSRScfs> Via a script, I have successfully exported and migrated
KSKSRScfs> all data and objects from a FB1 database to FB3.
KSKSRScfs> Creating the objects originally had just a few errors but
KSKSRScfs> those have been fixed and it now goes across cleanly, no errors.
KSKSRScfs> This process has been the one most widely recommended.

KSKSRScfs> Process 2:
KSKSRScfs> With the corrected database that goes cleanly to FB3, I tried the 
following:
KSKSRScfs> 1. Backup the database with FB1.
KSKSRScfs> 2. Restore the database with FB3.
KSKSRScfs> 3. Executed two of IB Expert’s functions: a) Recompile all
KSKSRScfs> Procedures and b) Recompile all Triggers.  (No errors)
KSKSRScfs> 4. Performed a backup / restore with no errors.

KSKSRScfs> My question:  is Process 2 an acceptable path?  The only
KSKSRScfs> reason I ask is one of my customers has many millions of
KSKSRScfs> records and I believe Process 2 will save me a weekend of
KSKSRScfs> work.  (My next step is to benchmark how long Process 1
KSKSRScfs> will take for this customer’s database).


KSKSRScfs> Many Thanks!

KSKSRScfs> Kevin

RE: [firebird-support] FB1 to FB3

['Jason (PN)' ja...@jac2.co.uk [firebird-support]]

Hi Kevin,

Can I ask what dialect you are going from and to?

 

Sorry I don’t have an opinion on P1 vs P2.  Do you know why P1 is recommended 
over P2?

 

As you may have guessed, I have this same thing to do 1.5.6 D1 -> ?.

 

Thanks,

Jason

 

From: firebird-support@yahoogroups.com  
Sent: 30 April 2020 15:23
To: Firebird Support 
Subject: [firebird-support] FB1 to FB3

 

  

Greetings!

Process 1:
Via a script, I have successfully exported and migrated all data and objects 
from a FB1 database to FB3.
Creating the objects originally had just a few errors but those have been fixed 
and it now goes across cleanly, no errors. 
This process has been the one most widely recommended.

Process 2:
With the corrected database that goes cleanly to FB3, I tried the following:
1. Backup the database with FB1.
2. Restore the database with FB3.
3. Executed two of IB Expert’s functions: a) Recompile all Procedures and b) 
Recompile all Triggers. (No errors)
4. Performed a backup / restore with no errors.

My question: is Process 2 an acceptable path? The only reason I ask is one of 
my customers has many millions of records and I believe Process 2 will save me 
a weekend of work. (My next step is to benchmark how long Process 1 will take 
for this customer’s database).

Many Thanks!

Kevin

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]

Re: [firebird-support] Firebird 2.5 and CentOS 7.7

[Philippe Makowski pmakow...@ibphoenix.fr [firebird-support]]

Are you using EPEL package ?
or Firebird project binaries ?

There is a compilation issue in Epel package since 2.5.8, and nobody
understand exactly what
fbintl from 2.5.7 package is ok

cf https://bugzilla.redhat.com/show_bug.cgi?id=1636177
and http://tracker.firebirdsql.org/browse/CORE-5925

but you can use firebird 3
https://copr.fedorainfracloud.org/coprs/makowski/firebird/

Re: [firebird-support] Firebird 2.5 and CentOS 7.7

[Emil Totev em...@tot-consult.com [firebird-support]]

This is a known problem with the EPEL rpms.
Workarounds include using the rpm packages for superclassic, which don't
have the problem, or installing the project-provided rpms (which install
under /opt). It *might* also work if you replace that specific file with
the one from the EPEL rpm from 2.5.7 (the problem appeared in 2.5.8).

Good luck!

Re: [firebird-support] Firebird 2.5 and CentOS 7.7

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

29.04.2020 15:40, 'P-Soft - Fabio Codebue' f.code...@p-soft.biz 
[firebird-support] wrote:
> Can't load INTL module '/usr/lib64/firebird/intl/fbintl.so'
> 
> Some ideas?

   Check dependencies using ldd.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] SQL slower after N executions?

[Svein Erling Tysvær setys...@gmail.com [firebird-support]]

I don't know why things slow down, Kjell, if the batch job updates records,
I guess it could be related to there being lots of versions of some records
and that garbage are only collected after your application ends (it sounds
plausible if transactions are still open when you "Stopping the batch and
restarting it, with the app still open". Maybe you should check if there's
a large gap between oldest and next transaction when you stop the batch
(similar to Karols first recommendation)? Another thing that would not harm
is to change from

  where Ar."Årtal" = ( select max( Ar2."Årtal" )
  from "FöretagOmsättningsår" FtgOmsar2
  inner join "År" Ar2 on Ar2.."ECO_ID" =
FtgOmsar2."Omsättningsår"
  where FtgOmsar2."Företag" = F."ECO_ID" )

to
 where not exists ( select 1
from "FöretagOmsättningsår" FtgOmsar2
inner join "År" Ar2 on Ar2.."ECO_ID" =
FtgOmsar2."Omsättningsår"
where FtgOmsar2."Företag" = F."ECO_ID"
  and Ar."Årtal" < Ar2."Årtal" )

in the second part of your query. This will probably not help with the
slowdown, but it should not be slower than your max( and it may be slightly
quicker (although the table names "FöretagOmsättningsår" and "År" does
indicate these are tiny tables).

Set

ons. 29. apr. 2020 kl. 13:44 skrev Kjell Rilbe
kjell.ri...@marknadsinformation.se [firebird-support] <
firebird-support@yahoogroups.com>:

> Hi,
>
> I have a batch job that among other things executes a certain SQL query
> to load some data.
>
> This query takes about 10-12 seconds the first ~320 times, but then
> suddenly takes ~45-50 seconds every time.
>
> Any idea what could be causing this?
>
> The query is rather long, see below. Firebird 3.0.4 on Windows Server
> 2016 64 bit. App is ASP Framework using FirebirdSql.Data.FirebirdClient
> 7.1.1.0.
>
> I can't see any other operations slowing down at the same point in time.
> I can't see any particular change in the app's memory usage (it varies
> up and down both before and after the time of slowdown). I did try a
> change of Firebird's cache settings (more page buffers), but it didn't
> seem to have any effect (yes I did restart FB service to ensure changes
> took effect). Windows file system cache doesn't seem to hit the roof at
> this particular time, so I see no connection there.
>
> Stopping the batch and restarting it, with the app still open, doesn't
> help, but restarting the entire app leads to the shorter execution time
> again.
>
> Each execution of this SQL query is done in a new connection (not
> pooled). Before this SQL, the same connection is also used to empty the
> table "TmpFKExportId" and then fill it with some new data, a simple list
> of 250 bigints).
>
> The app does do other DB work that spans multiple executions of this SQL
> query, using a separate connection. Those operations do not exhibit any
> noticable slowdown.
>
> I'm at a loss... Any suggestions of things to try are most welcome!
>
> SQL:
>
> select distinct Upg."ECO_ID", Upg."ECO_TYPE"
> from (
>  select 'Företag' "Bärartyp", F."ECO_ID" "Bärare", Uhant."ECO_ID"
>  from "Företag" F
>  inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
>  inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" =
> F."Uppgiftshanterare"
>  union
>  select 'FöretagOmsättningsår' "Bärartyp", FtgOmsar."ECO_ID"
> "Bärare", Uhant."ECO_ID"
>  from "Företag" F
>  inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
>  inner join "FöretagOmsättningsår" FtgOmsar on FtgOmsar."Företag" =
> F."ECO_ID"
>  inner join "År" Ar on Ar."ECO_ID" = FtgOmsar."Omsättningsår"
>  inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" =
> FtgOmsar."Uppgiftshanterare"
>  where Ar."Årtal" = (
>  select max(Ar2."Årtal")
>  from "FöretagOmsättningsår" FtgOmsar2
>  inner join "År" Ar2 on Ar2.."ECO_ID" = FtgOmsar2."Omsättningsår"
>  where FtgOmsar2."Företag" = F."ECO_ID"
>)
>  union
>  select 'ITmiljö' "Bärartyp", ITmilj."ECO_ID" "Bärare", Uhant."ECO_ID"
>  from "Företag" F
>  inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
>  inner join "ITmiljö" ITmilj on ITmilj."ECO_ID" = F."ITmiljö"
>  inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" =
> ITmilj."Uppgiftshanterare"
>  union
>  select 'Befattningsinnehav' "Bärartyp", BI."ECO_ID" "Bärare",
> Uhant."ECO_ID"
>  from "Företag" F
>  inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
>  inner join "Befattningsinnehav" BI on BI."Företag" = F."ECO_ID"
>  inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" =
> BI."Uppgiftshanterare"
>  union
>  select 'Person' "Bärartyp", P."ECO_ID" "Bärare", Uhant."ECO_ID"
>  from "Företag" F
>  inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
>  inner join "Befattningsinnehav" BI on BI."Företag" 

Re: [firebird-support] How to inspect nbak state of a Firebird database

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

Excellent! Thanks!

Feel free to anser that in StackOverflow too (link below). If not, I 
will do it myself after testing it and mark my own answer as the correct 
one.

Regards,
Kjell

Den 2020-04-22 kl. 10:08, skrev 'Paul Beach' pbe...@mail.ibphoenix.com 
[firebird-support]:

>
> MON$TABLES -> MON$BACKUP_STATE -> 0 - Normal, 1 - Stalled, 2 - Merge.
>
> Regards
> Paul
>
> -Original Message-
> From: firebird-support@yahoogroups.com 
> [mailto:firebird-support@yahoogroups.com]
> Sent: 22 April 2020 09:56
> To: Firebird Forum
> Subject: [firebird-support] How to inspect nbak state of a Firebird 
> database
>
> Is there a way in C# to inspect the nbak state of a Firebird database?
>
> The state in the database header would be set to |nbak_state_diff| or
> |nbak_state_normal|. But how do I actually read this value?
>
> https://stackoverflow.com/questions/61359915/how-to-inspect-nbak-state-of-a-firebird-database
>



[Non-text portions of this message have been removed]

RE: [firebird-support] How to inspect nbak state of a Firebird database

['Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]]

MON$TABLES -> MON$BACKUP_STATE -> 0 - Normal, 1 - Stalled, 2 - Merge.

Regards
Paul

-Original Message-
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 22 April 2020 09:56
To: Firebird Forum
Subject: [firebird-support] How to inspect nbak state of a Firebird database


  
Is there a way in C# to inspect the nbak state of a Firebird database?

The state in the database header would be set to |nbak_state_diff| or 
|nbak_state_normal|. But how do I actually read this value?

https://stackoverflow.com/questions/61359915/how-to-inspect-nbak-state-of-a-firebird-database

Regards,
Kjell

[Non-text portions of this message have been removed]

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

18.04.2020 18:56, Shane delphi_ric...@yahoo.co.uk [firebird-support] wrote:
> But Like I said Errors where produced with restoring, like size error

   A new feature for you to learn: copy-paste from console window to mail 
client.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 18-04-2020 18:56, Shane delphi_ric...@yahoo.co.uk [firebird-support] 
wrote:
> 
> 
> Yes sorry, this is from Linux. Since I'm a Linux Enthusiast . I did that 
> script, but it did produce errors.
> 
> http://www.firebirdfaq.org/faq141/ This is the backup script I used.
> 
> This page I used  for the restore string 
> http://www.destructor.de/firebird/gbak.htm. But Like I said Errors where 
> produced with restoring, like size error

Please be explicit with what you tried and the exact errors you get.

Mark

-- 
Mark Rotteveel

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[Shane delphi_ric...@yahoo.co.uk [firebird-support]]

Yes sorry, this is from Linux. Since I'm a Linux Enthusiast . I did that 
script, but it did produce errors.


http://www.firebirdfaq.org/faq141/ This is the backup script I used.

This page I used  for the restore string 
http://www.destructor.de/firebird/gbak.htm. But Like I said Errors where 
produced with restoring, like size error


On 17/04/2020 17:22, John vdW j...@jvdw.nl [firebird-support] wrote:


For gbak on a windows machine:

"c:\Program files\Firebird\Firebird_2_5\bin\gbak" -c -v -user SYSDBA 
-pas masterkey backupfilename.fbk targetfilename.fdb


-c to create a new file
-v to be verbose and show on screen what's happening
- user and password


Op 18-04-2020 om 17:58 schreef Shane delphi_ric...@yahoo.co.uk 
[firebird-support]:
The Firebird version was not tampered with in this fault. Although 
what's I thought was strange is the support person uninstalled 
Firebird then re-installed. I never saw him going to Microsoft 
service file to stop Firebird.


Could someone give me the script to restore a .fbk file. I kept on 
getting a file size error.


On 17/04/2020 15:17, John vdW j...@jvdw.nl [firebird-support] wrote:


Actually I meant the Firebird Server version. Are they the same on 
Linux and Windows?


GBak is designed to make a backup on the fly, even with many users 
connected and using the database. No need to shut down.


Make sure the gbak-restore creates a new file and does not write 
into an existing database file.





Op 18-04-2020 om 16:01 schreef Shane delphi_ric...@yahoo.co.uk 
[firebird-support]:
I agree with the version, as the company comes out with different 
version of there client software, that does an update change.
The other part of not switch off the Firebird before copying would 
create a fault even though no one was working on the database?
Because I did try making sure the Client program running from the 
Linux server through Samba will be the exact version as the one 
running correctly from Windows XP, which works.
Still showing it's corrupted, according to the support person from 
Delfin company.



On 17/04/2020 13:53, DougC d...@moosemail.net [firebird-support] wrote:
In your description you did not include a step to shutdown the 
server or database on Windows before copying it to Linux. Did you 
do that?


Doug C.


 On Fri, 17 Apr 2020 05:21:03 -0400 *Shane 
delphi_ric...@yahoo.co.uk [firebird-support] 
* wrote 


I've been dealing with this company support.
https://www.delter.co.za/
I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database,
from
Windows to the Linux file system through Windows. Deactivate
Linux
firebird 2.5 first then replace the database. Reactivate the
database on
Linux. Then start a Windows program that communicates with the
database
from an IP address.
The software developer has somehow put a hook in the software.
That if
the path has changed the database needs to be reset, as in
re-registered.
The big frustration I'm having is the file I'm copying is not
corrupt.
But when I'm starting it from the Linux server. It corrupt.
This is according to the support person from delfin.
Originally the firebird database was working perfectly on the
Linux
computer.
There is something in there software to me that has changed
that somehow
won't see the Database correctly.

Really hope someone could halp clarify why the database goes
from not
corrupt from Windows to corrupt on Linux.

Kind Regards
Shane

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[John vdW j...@jvdw.nl [firebird-support]]

For gbak on a windows machine:

"c:\Program files\Firebird\Firebird_2_5\bin\gbak" -c -v -user SYSDBA 
-pas masterkey backupfilename.fbk targetfilename.fdb


-c to create a new file
-v to be verbose and show on screen what's happening
- user and password


Op 18-04-2020 om 17:58 schreef Shane delphi_ric...@yahoo.co.uk 
[firebird-support]:



The Firebird version was not tampered with in this fault. Although 
what's I thought was strange is the support person uninstalled 
Firebird then re-installed. I never saw him going to Microsoft service 
file to stop Firebird.


Could someone give me the script to restore a .fbk file. I kept on 
getting a file size error.


On 17/04/2020 15:17, John vdW j...@jvdw.nl [firebird-support] wrote:


Actually I meant the Firebird Server version. Are they the same on 
Linux and Windows?


GBak is designed to make a backup on the fly, even with many users 
connected and using the database. No need to shut down.


Make sure the gbak-restore creates a new file and does not write into 
an existing database file.





Op 18-04-2020 om 16:01 schreef Shane delphi_ric...@yahoo.co.uk 
[firebird-support]:
I agree with the version, as the company comes out with different 
version of there client software, that does an update change.
The other part of not switch off the Firebird before copying would 
create a fault even though no one was working on the database?
Because I did try making sure the Client program running from the 
Linux server through Samba will be the exact version as the one 
running correctly from Windows XP, which works.
Still showing it's corrupted, according to the support person from 
Delfin company.



On 17/04/2020 13:53, DougC d...@moosemail.net [firebird-support] wrote:
In your description you did not include a step to shutdown the 
server or database on Windows before copying it to Linux. Did you 
do that?


Doug C.


 On Fri, 17 Apr 2020 05:21:03 -0400 *Shane 
delphi_ric...@yahoo.co.uk [firebird-support] 
* wrote 


I've been dealing with this company support.
https://www.delter.co.za/
I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database, from
Windows to the Linux file system through Windows. Deactivate Linux
firebird 2.5 first then replace the database. Reactivate the
database on
Linux. Then start a Windows program that communicates with the
database
from an IP address.
The software developer has somehow put a hook in the software.
That if
the path has changed the database needs to be reset, as in
re-registered.
The big frustration I'm having is the file I'm copying is not
corrupt.
But when I'm starting it from the Linux server. It corrupt.
This is according to the support person from delfin.
Originally the firebird database was working perfectly on the
Linux
computer.
There is something in there software to me that has changed
that somehow
won't see the Database correctly.

Really hope someone could halp clarify why the database goes
from not
corrupt from Windows to corrupt on Linux.

Kind Regards
Shane

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[Shane delphi_ric...@yahoo.co.uk [firebird-support]]

The Firebird version was not tampered with in this fault. Although 
what's I thought was strange is the support person uninstalled Firebird 
then re-installed. I never saw him going to Microsoft service file to 
stop Firebird.


Could someone give me the script to restore a .fbk file. I kept on 
getting a file size error.


On 17/04/2020 15:17, John vdW j...@jvdw.nl [firebird-support] wrote:


Actually I meant the Firebird Server version. Are they the same on 
Linux and Windows?


GBak is designed to make a backup on the fly, even with many users 
connected and using the database. No need to shut down.


Make sure the gbak-restore creates a new file and does not write into 
an existing database file.





Op 18-04-2020 om 16:01 schreef Shane delphi_ric...@yahoo.co.uk 
[firebird-support]:
I agree with the version, as the company comes out with different 
version of there client software, that does an update change.
The other part of not switch off the Firebird before copying would 
create a fault even though no one was working on the database?
Because I did try making sure the Client program running from the 
Linux server through Samba will be the exact version as the one 
running correctly from Windows XP, which works.
Still showing it's corrupted, according to the support person from 
Delfin company.



On 17/04/2020 13:53, DougC d...@moosemail.net [firebird-support] wrote:
In your description you did not include a step to shutdown the 
server or database on Windows before copying it to Linux. Did you do 
that?


Doug C.


 On Fri, 17 Apr 2020 05:21:03 -0400 *Shane 
delphi_ric...@yahoo.co.uk [firebird-support] 
* wrote 


I've been dealing with this company support.
https://www.delter.co.za/
I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database, from
Windows to the Linux file system through Windows. Deactivate Linux
firebird 2.5 first then replace the database. Reactivate the
database on
Linux. Then start a Windows program that communicates with the
database
from an IP address.
The software developer has somehow put a hook in the software.
That if
the path has changed the database needs to be reset, as in
re-registered.
The big frustration I'm having is the file I'm copying is not
corrupt.
But when I'm starting it from the Linux server. It corrupt.
This is according to the support person from delfin.
Originally the firebird database was working perfectly on the Linux
computer.
There is something in there software to me that has changed that
somehow
won't see the Database correctly.

Really hope someone could halp clarify why the database goes
from not
corrupt from Windows to corrupt on Linux.

Kind Regards
Shane

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[John vdW j...@jvdw.nl [firebird-support]]

Actually I meant the Firebird Server version. Are they the same on Linux 
and Windows?


GBak is designed to make a backup on the fly, even with many users 
connected and using the database. No need to shut down.


Make sure the gbak-restore creates a new file and does not write into an 
existing database file.





Op 18-04-2020 om 16:01 schreef Shane delphi_ric...@yahoo.co.uk 
[firebird-support]:



I agree with the version, as the company comes out with different 
version of there client software, that does an update change.
The other part of not switch off the Firebird before copying would 
create a fault even though no one was working on the database?
Because I did try making sure the Client program running from the 
Linux server through Samba will be the exact version as the one 
running correctly from Windows XP, which works.
Still showing it's corrupted, according to the support person from 
Delfin company.



On 17/04/2020 13:53, DougC d...@moosemail.net [firebird-support] wrote:
In your description you did not include a step to shutdown the server 
or database on Windows before copying it to Linux. Did you do that?


Doug C.


 On Fri, 17 Apr 2020 05:21:03 -0400 *Shane 
delphi_ric...@yahoo.co.uk [firebird-support] 
* wrote 


I've been dealing with this company support.
https://www.delter.co.za/
I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database, from
Windows to the Linux file system through Windows. Deactivate Linux
firebird 2.5 first then replace the database. Reactivate the
database on
Linux. Then start a Windows program that communicates with the
database
from an IP address.
The software developer has somehow put a hook in the software.
That if
the path has changed the database needs to be reset, as in
re-registered.
The big frustration I'm having is the file I'm copying is not
corrupt.
But when I'm starting it from the Linux server. It corrupt.
This is according to the support person from delfin.
Originally the firebird database was working perfectly on the Linux
computer.
There is something in there software to me that has changed that
somehow
won't see the Database correctly.

Really hope someone could halp clarify why the database goes from
not
corrupt from Windows to corrupt on Linux.

Kind Regards
Shane

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[Shane delphi_ric...@yahoo.co.uk [firebird-support]]

I agree with the version, as the company comes out with different 
version of there client software, that does an update change.
The other part of not switch off the Firebird before copying would 
create a fault even though no one was working on the database?
Because I did try making sure the Client program running from the Linux 
server through Samba will be the exact version as the one running 
correctly from Windows XP, which works.
Still showing it's corrupted, according to the support person from 
Delfin company.



On 17/04/2020 13:53, DougC d...@moosemail.net [firebird-support] wrote:
In your description you did not include a step to shutdown the server 
or database on Windows before copying it to Linux. Did you do that?


Doug C.


 On Fri, 17 Apr 2020 05:21:03 -0400 *Shane 
delphi_ric...@yahoo.co.uk [firebird-support] 
* wrote 


I've been dealing with this company support. https://www.delter.co.za/
I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database, from
Windows to the Linux file system through Windows. Deactivate Linux
firebird 2.5 first then replace the database. Reactivate the
database on
Linux. Then start a Windows program that communicates with the
database
from an IP address.
The software developer has somehow put a hook in the software.
That if
the path has changed the database needs to be reset, as in
re-registered.
The big frustration I'm having is the file I'm copying is not
corrupt.
But when I'm starting it from the Linux server. It corrupt.
This is according to the support person from delfin.
Originally the firebird database was working perfectly on the Linux
computer.
There is something in there software to me that has changed that
somehow
won't see the Database correctly.

Really hope someone could halp clarify why the database goes from not
corrupt from Windows to corrupt on Linux.

Kind Regards
Shane

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[DougC d...@moosemail.net [firebird-support]]

In your description you did not include a step to shutdown the server or 
database on Windows before copying it to Linux. Did you do that?



Doug C.



 On Fri, 17 Apr 2020 05:21:03 -0400 Shane delphi_ric...@yahoo.co.uk 
[firebird-support]  wrote 


 I've been dealing with this company support. https://www.delter.co.za/
 I'm an IT professional. Support Windows, Linux, Apple Mac.
 I have a technical question. When I copy a firebird database, from 
 Windows to the Linux file system through Windows. Deactivate Linux 
 firebird 2.5 first then replace the database. Reactivate the database on 
 Linux. Then start a Windows program that communicates with the database 
 from an IP address.
 The software developer has somehow put a hook in the software. That if 
 the path has changed the database needs to be reset, as in re-registered.
 The big frustration I'm having is the file I'm copying is not corrupt. 
 But when I'm starting it from the Linux server. It corrupt.
 This is according to the support person from delfin.
 Originally the firebird database was working perfectly on the Linux 
 computer.
 There is something in there software to me that has changed that somehow 
 won't see the Database correctly.
 
 Really hope someone could halp clarify why the database goes from not 
 corrupt from Windows to corrupt on Linux.
 
 Kind Regards
 Shane

Re: [firebird-support] Technical IT specialist Firebird corruption

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 17-04-2020 13:35, Nick Upson nick.up...@gmail.com [firebird-support] 
wrote:
> I've had a similar issue when the database code was looking for custom 
> UDF's that had not been installed on the destination, in some ways that 
> can appear as corruption even though it isn't

In Firebird itself that would result in an error like "invalid request - 
 is not defined - module name or entrypoint could not be 
found" error.

Unless of course the application in question is hiding that error and 
returning unclear errors.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] Technical IT specialist Firebird corruption

[Nick Upson nick.up...@gmail.com [firebird-support]]

I've had a similar issue when the database code was looking for custom
UDF's that had not been installed on the destination, in some ways that can
appear as corruption even though it isn't
--
Nick


On Fri, 17 Apr 2020 at 12:15, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support]  wrote:

>
>
> On 18-04-2020 12:19, Shane delphi_ric...@yahoo.co.uk [firebird-support]
> wrote:
> > The scenario that I've setup is Opensuse is the main OS. I'm running
> > Windows XP on a VirtualBox. So within Windows XP I communicate to the
> > Linux OS through samba, copying to the folder the database is running. I
> > do the systemctl stop to Firebird on the Linux Server then restart after
> > it's finished copying .
>
> What exactly are you copying? How are you moving the database from
> Windows to Linux, what are the exact steps and commands used? If you
> were using gbak to backup and restore, there would be no need to stop
> Firebird on your Linux server. So it sounds like you are copying the
> database file itself, instead of using gbak to back it up on Windows and
> then - using gbak - restore it on Linux.
>
> > I did use the gbak on all the backups. I even tried Flamerobin to
> > restore resent backups. which it didn't give any errors.
> > But it does want to be registered and the Defin support person says it
> > corrupted!!!
>
> Then possibly this might be a problem with the application and not so
> much with the database. You would need to contact support of your
> application for more help.
>
> Mark
> --
> Mark Rotteveel
> 
>

Re: [firebird-support] Technical IT specialist Firebird corruption

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 18-04-2020 12:19, Shane delphi_ric...@yahoo.co.uk [firebird-support] 
wrote:
> The scenario that I've setup is Opensuse is the main OS. I'm running 
> Windows XP on a VirtualBox. So within Windows XP I communicate to the 
> Linux OS through samba, copying to the folder the database is running. I 
> do the systemctl stop to Firebird on the Linux Server then restart after 
> it's finished copying .

What exactly are you copying? How are you moving the database from 
Windows to Linux, what are the exact steps and commands used? If you 
were using gbak to backup and restore, there would be no need to stop 
Firebird on your Linux server. So it sounds like you are copying the 
database file itself, instead of using gbak to back it up on Windows and 
then - using gbak - restore it on Linux.

> I did use the gbak on all the backups. I even tried Flamerobin to 
> restore resent backups. which it didn't give any errors.
> But it does want to be registered and the Defin support person says it 
> corrupted!!!

Then possibly this might be a problem with the application and not so 
much with the database. You would need to contact support of your 
application for more help.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] Technical IT specialist Firebird corruption

[John vdW j...@jvdw.nl [firebird-support]]

Maybe there is a version issue? If you can connect to the restored database 
through Flamerobin and browse the tables, then there's probably nothing wrong 
with the database. But if the clientprogram and it's library expect a certain 
version and the version is different, they may respond with a generic error 
like "database corrupted"


Sent from my iPhone

> On 17 Apr 2020, at 11:17, Shane delphi_ric...@yahoo.co.uk [firebird-support] 
>  wrote:
> 
>  
> 
> Thank you very much for the quick reply.
> 
> The scenario that I've setup is Opensuse is the main OS. I'm running Windows 
> XP on a VirtualBox. So within Windows XP I communicate to the Linux OS 
> through samba, copying to the folder the database is running. I do the 
> systemctl stop to Firebird on the Linux Server then restart after it's 
> finished copying .
> 
> I did use the gbak on all the backups. I even tried Flamerobin to restore 
> resent backups. which it didn't give any errors.
> But it does want to be registered and the Defin support person says it 
> corrupted!!!
> 
> If I think of a different scenario were I use an Accounting program called 
> Turbocash. Take the firebird database copy it to a linux file system. Use 
> Playonlinux to open Turbocash and open the database that I've copied from 
> Windows. It works 100% and I can move it back from Linux to Windows without 
> any fault.
> 
> 
> On 17/04/2020 10:56, John vdW j...@jvdw.nl [firebird-support] wrote:
>> Shane,
>> 
>> AFAIK, ALWAYS use a Backup/Restore cycle when moving a Firebird database 
>> from one computer to another, especially from one OS to a different OS.
>> 
>> Use the Gbak tool on the original machine to create a backup file.
>> 
>> Use the GBak tool on the target machine to restore the backupfile to a FB 
>> database.
>> 
>> Good luck!
>> John
>> 
>> Op 17-04-2020 om 10:47 schreef Shane Richmond delphi_ric...@yahoo.co.uk 
>> [firebird-support]:
>>> I see the Group is on Yahoo. Which I have also an account for a very long 
>>> time.
>>> 
>>> 
>>> I've been dealing with this company support. https://www.delter.co.za/
>>> I'm an IT professional. Support Windows, Linux, Apple Mac.
>>> I have a technical question. When I copy a firebird database, from Windows 
>>> to the Linux file system through Windows. Deactivate Linux firebird 2.5 
>>> first then replace the database. Reactivate the database on Linux. Then 
>>> start a Windows program that communicates with the database from an IP 
>>> address.
>>> The software developer has somehow put a hook in the software. That if the 
>>> path has changed the database needs to be reset, as in re-registered. 
>>> The big frustration I'm having is the file I'm copying is not corrupt. But 
>>> when I'm starting it from the Linux server. It corrupt.
>>> This is according to the support purson from delfin.
>>> Originally the firebird database was working perfectly on the Linux 
>>> computer.
>>> There is something in there software to me that has changed that somehow 
>>> won't see the Database correctly.
>>> 
>>> Really hope someone could halp clarify why the database goes from not 
>>> corrupt from Windows to corrupt on Linux.
>>> 
>>> Kind Regards
>>> Shane
>>> 
>> 
> 
> 
> 
> 

Re: [firebird-support] Technical IT specialist Firebird corruption

[Shane delphi_ric...@yahoo.co.uk [firebird-support]]

Thank you very much for the quick reply.

The scenario that I've setup is Opensuse is the main OS. I'm running 
Windows XP on a VirtualBox. So within Windows XP I communicate to the 
Linux OS through samba, copying to the folder the database is running. I 
do the systemctl stop to Firebird on the Linux Server then restart after 
it's finished copying .


I did use the gbak on all the backups. I even tried Flamerobin to 
restore resent backups. which it didn't give any errors.
But it does want to be registered and the Defin support person says it 
corrupted!!!


If I think of a different scenario were I use an Accounting program 
called Turbocash. Take the firebird database copy it to a linux file 
system. Use Playonlinux to open Turbocash and open the database that 
I've copied from Windows. It works 100% and I can move it back from 
Linux to Windows without any fault.



On 17/04/2020 10:56, John vdW j...@jvdw.nl [firebird-support] wrote:


Shane,

AFAIK, ALWAYS use a Backup/Restore cycle when moving a Firebird 
database from one computer to another, especially from one OS to a 
different OS.


Use the Gbak tool on the original machine to create a backup file.

Use the GBak tool on the target machine to restore the backupfile to a 
FB database.


Good luck!
John

Op 17-04-2020 om 10:47 schreef Shane Richmond 
delphi_ric...@yahoo.co.uk [firebird-support]:
I see the Group is on Yahoo. Which I have also an account for a very 
long time.



I've been dealing with this company support. 
https://www.delter.co.za/ 

I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database, from 
Windows to the Linux file system through Windows. Deactivate Linux 
firebird 2.5 first then replace the database. Reactivate the database 
on Linux. Then start a Windows program that communicates with the 
database from an IP address.
The software developer has somehow put a hook in the software. That 
if the path has changed the database needs to be reset, as in 
re-registered.
The big frustration I'm having is the file I'm copying is not 
corrupt. But when I'm starting it from the Linux server. It corrupt.

This is according to the support purson from delfin.
Originally the firebird database was working perfectly on the Linux 
computer.
There is something in there software to me that has changed that 
somehow won't see the Database correctly.


Really hope someone could halp clarify why the database goes from not 
corrupt from Windows to corrupt on Linux.


Kind Regards
Shane

Re: [firebird-support] Technical IT specialist Firebird corruption

[John vdW j...@jvdw.nl [firebird-support]]

Shane,

AFAIK, ALWAYS use a Backup/Restore cycle when moving a Firebird database 
from one computer to another, especially from one OS to a different OS.


Use the Gbak tool on the original machine to create a backup file.

Use the GBak tool on the target machine to restore the backupfile to a 
FB database.


Good luck!
John

Op 17-04-2020 om 10:47 schreef Shane Richmond delphi_ric...@yahoo.co.uk 
[firebird-support]:



I see the Group is on Yahoo. Which I have also an account for a very 
long time.



I've been dealing with this company support. https://www.delter.co.za/ 


I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database, from 
Windows to the Linux file system through Windows. Deactivate Linux 
firebird 2.5 first then replace the database. Reactivate the database 
on Linux. Then start a Windows program that communicates with the 
database from an IP address.
The software developer has somehow put a hook in the software. That if 
the path has changed the database needs to be reset, as in re-registered.
The big frustration I'm having is the file I'm copying is not corrupt. 
But when I'm starting it from the Linux server. It corrupt.

This is according to the support purson from delfin.
Originally the firebird database was working perfectly on the Linux 
computer.
There is something in there software to me that has changed that 
somehow won't see the Database correctly.


Really hope someone could halp clarify why the database goes from not 
corrupt from Windows to corrupt on Linux.


Kind Regards
Shane

Re: [firebird-support] List Users after CREATE/DROP USER without commit

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 11-04-2020 11:41, Lukas Gradl fireb...@ssn.at [firebird-support] wrote:
> Hi @all!
> 
> I'm trying to implement some sort of user manager into an app and want
> to use the firebird-users and roles as user and authentification
> source (using FB 3).
> 
> Most of it works perfectly. There's just one little problem:
> If I create or drop a user via CREATE USER or DROP USER and do a
> "SELECT * FROM SEC$USERS" afterwards the change is not visible - the
> new user is missing, the dropped user is still in the list.
> 
> I'm using the same transaction for all the commands but still I have
> to issue a COMMIT for seeing the changes in the user list.
> 
> Now I'd love to use the transaction-mechanism for giving the user of
> my app a possibility to revoke the changes made.
> 
> Can this be achived somehow?

No, it cannot. Creation of the user happens in a different database, and 
changes in that database aren't visible until the commit happens (at 
which time the commit in the security database happens as well).

Mark
-- 
Mark Rotteveel

Re: [firebird-support] List Users after CREATE/DROP USER without commit

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

11.04.2020 11:41, Lukas Gradl fireb...@ssn.at [firebird-support] wrote:
> Now I'd love to use the transaction-mechanism for giving the user of
> my app a possibility to revoke the changes made.
> 
> Can this be achived somehow?

   User management is outside of database and performed in an autonomous 
transaction. To 
see results of the query you, probably, have to use read-committed isolation 
level.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Forgot sysdba password

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 2020-04-09 18:05, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] wrote:
> On 2020-04-09 09:53, liviuslivius liviusliv...@poczta.onet.pl
> [firebird-support] wrote:
>> Hi
>> 
>> Simply replace security3.fdb by ine from the zip install and
>> initialize sysdba
> 
> Doing that will lose all other users in the security database, so that
> is not a good idea.
> 
> Instead, stop Firebird server, and use
> 
> isql -user sysdba employee
> 
> and then
> 
> alter user sysdba password 'new password';
> commit;
> exit;

And of course, start Firebird server again.

Mark

Re: [firebird-support] Forgot sysdba password

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 2020-04-09 09:53, liviuslivius liviusliv...@poczta.onet.pl 
[firebird-support] wrote:
> Hi
> 
> Simply replace security3.fdb by ine from the zip install and
> initialize sysdba

Doing that will lose all other users in the security database, so that 
is not a good idea.

Instead, stop Firebird server, and use

isql -user sysdba employee

and then

alter user sysdba password 'new password';
commit;
exit;

Mark

Re: [firebird-support] Forgot sysdba password

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

09.04.2020 06:47, Andrea Raimondi andrea.raimo...@gmail.com [firebird-support] 
wrote:
> What I'd like to do is to reset the pw to something known

   Connect to any database in embedded mode with user name SYSDBA (without 
password) and 
use ALTER USER query.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

RE: [firebird-support] Forgot sysdba password

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

HiSimply replace security3.fdb by ine from the zip install and initialize 
sysdbaRegards,Karol Bieniaszewski
null

Re: [firebird-support] error during the registratione of data on 2.5 FB database

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 04-04-2020 13:01, 'Stellarancia.com' ni...@stellarancia.com 
[firebird-support] wrote:
> No, there is not a trigger.
> 
> You say than the error is referred to another part (with mistaken value)
> of the entire script... but the compiler reports me the part that
> (maybe) run ok?!? How this is possible?

That is not what I said. Please read what I wrote again.

> Ok, print the script and study it.

I suggest that you do the work to make it as easy for us to help you. 
That means creating a minimal reproducible example that does not require 
any other tools than ISQL to reproduce the problem. Very likely while 
doing that, you will already find the problem yourself.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] error during the registratione of data on 2.5 FB database

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

No, there is not a trigger.

You say than the error is referred to another part (with mistaken value) 
of the entire script... but the compiler reports me the part that 
(maybe) run ok?!? How this is possible?

Ok, print the script and study it.

Antonio Bianca


Il 04/04/2020 10:57, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] ha scritto:
>
> On 04-04-2020 10:49, 'Stellarancia.com' ni...@stellarancia..com
> [firebird-support] wrote:
> > He,
> > I've an error that I don't undestrand.
> > I use Delphi 7 environment to create my applications, Zeos components
> > for connections and Firebird 2.5 Superserver for database management.
> > To register the data, my App uses the processor component; the
> > Connection.Autocommit  parameter is set to False.
> > My App inserts numerous lines of data to be recorded in the Process
> > component (with Process.Script.Add('...') -> 'UPDATE XY SET...'; INSERT
> > INTO ZXD...'; UPDATE FGH SET ...'; and so on);
> > at the end, it adds the command "COMMIT;", then call "PARSE", and 
> "EXECUTE".
> > The lines 4 and 5 of the processor script contains the data mistaken,
> > but I don't undestand where is the eror.
> > The exception raised by the server is:
> > ---
> >
> > SQL Error:  conversion error from string "". Error Code: -413. Overflow
> > occurred during data type conversion.
> > The SQL: INSERT INTO ANA_DIPE_PRESORD (COD_REC, MATR, DATORE, POSIZ,
> > MESE, ANNO)
> > VALUES (30030003004601, 3, 46, 1, 03, 2020)
> > ;
> >
> > --
> > This is the table declaration:
> > --
> Do you have a trigger on the table? Given the STATO column has a default
> of '', maybe a trigger tries to convert that to a number somewhere?
>
> Also, are you absolutely sure this is the statement that causes the
> problem. Your trying to execute a script, which Firebird itself does not
> support, so your component is doing some transformations, which might
> mean that the error is not on the line that you think it is. Try
> executing a single statement instead of a script.
>
> I'd recommend trying to reproduce it in ISQL, and if possible provide us
> with a minimum reproducible example
>
> Mark
> -- 
> Mark Rotteveel
>
>

Re: [firebird-support] error during the registratione of data on 2.5 FB database

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 04-04-2020 10:49, 'Stellarancia.com' ni...@stellarancia.com 
[firebird-support] wrote:
> He,
> I've an error that I don't undestrand.
> I use Delphi 7 environment to create my applications, Zeos components
> for connections and Firebird 2.5 Superserver for database management.
> To register the data, my App uses the processor component; the
> Connection.Autocommit  parameter is set to False.
> My App inserts numerous lines of data to be recorded in the Process
> component (with Process.Script.Add('...') -> 'UPDATE XY SET...'; INSERT
> INTO ZXD...'; UPDATE FGH SET ...'; and so on);
> at the end, it adds the command "COMMIT;", then call "PARSE", and "EXECUTE".
> The lines 4 and 5 of the processor script contains the data mistaken,
> but I don't undestand where is the eror.
> The exception raised by the server is:
> ---
> 
> SQL Error:  conversion error from string "". Error Code: -413. Overflow
> occurred during data type conversion.
> The SQL: INSERT INTO ANA_DIPE_PRESORD (COD_REC, MATR, DATORE, POSIZ,
> MESE, ANNO)
> VALUES (30030003004601, 3, 46, 1, 03, 2020)
> ;
> 
> --
> This is the table declaration:
> --
> 
> CREATE TABLE ANA_DIPE_PRESORD
> (
>     COD_REC Bigint NOT NULL,
>     ANNO Smallint DEFAULT 0,
>     MESE Smallint DEFAULT 0,
>     MATR Smallint DEFAULT 0,
>     DATORE Smallint DEFAULT 0,
>     POSIZ Smallint DEFAULT 0,
>     STATO Char(1) DEFAULT ''
>     CONSTRAINT PK_DIPPPREORD
>       PRIMARY KEY (COD_REC)
> );
> 
> CREATE UNIQUE INDEX IND_ANADPPREORD_COD ON ANA_DIPE_PRESORD (COD_REC);
> GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
>    ON ANA_DIPE_PRESORD TO  SYSDBA WITH GRANT OPTION;
> 
> --
> 
> The Table has no trigger, no generators, no stored procedures connected.
> The data in "COD_REC" must be unique.
> 
> No data are sent as  '' (void string), neither any value is sent as
> "Quoted string",
> because they are all of type smallint (and bigint).
> I'm going crazy.
> It's stupid, but I've changed the value for field 'MESE' from '03' to
> '3', but the result is the same.
> What can be the reason?
> Thanks for reply.

Do you have a trigger on the table? Given the STATO column has a default 
of '', maybe a trigger tries to convert that to a number somewhere?

Also, are you absolutely sure this is the statement that causes the 
problem. Your trying to execute a script, which Firebird itself does not 
support, so your component is doing some transformations, which might 
mean that the error is not on the line that you think it is. Try 
executing a single statement instead of a script.

I'd recommend trying to reproduce it in ISQL, and if possible provide us 
with a minimum reproducible example

Mark
-- 
Mark Rotteveel

Re: [firebird-support] Potential for improvements / optimization for the use case below?

[Patrick Marten patrick_mar...@yahoo.com [firebird-support]]

 Thank you for your reply, Lester.
I came across CTE during my research, but wasn't sure it was the right thing 
for this case. Looked more detailed into it and came up with this:
with TOTAL_STOCKS as (
  select PRODUCTID,
 STORAGE_AREA_ID_SOURCE,
 sum(AMOUNT) as TOTAL_STOCK
  from STOCK_RECORDS
  where STOCK_RELEVANT = -1
  group by PRODUCTID, STORAGE_AREA_ID_SOURCE
)
select sr.ID,
   sr.STORAGE_AREA_ID_SOURCE,
   sr.INSERTDATE,
   sr.EDITDATE,
   sr.PRODUCTID,
   sr.RECORD_DATE,
   sr.DELIVERYPOSID as POSID,
   sr.INSTANCE_TYPE,
   sr.INSTANCE_ID,
   abs(sr.AMOUNT) as AMOUNT,
   sr.STORAGE_AREA_ID_SOURCE,
   ts.TOTAL_STOCK as RESULTING_AMOUNT
from STOCK_RECORDS sr
 left join TOTAL_STOCKS ts
   on sr.STORAGE_AREA_ID_SOURCE = ts.STORAGE_AREA_ID_SOURCE and 
sr.PRODUCTID = ts.PRODUCTID
where sr.INSTANCE_TYPE = 2
If that's correct, then there is still one thing I have trouble with: the 
sum(AMOUNT) aka RESULTING_AMOUNT has to be based on the field EDITDATE, i.e. I 
need an amount for each row, which was the TOTAL AMOUNT back then, i.e. prior 
to EDITDATE in the said row. There are actually some more criteria to exclude 
some rows, but if there is a solution for EDITDATE, that would be similar for 
the rest.
If I do 

with TOTAL_STOCKS as (
  select PRODUCTID,
 STORAGE_AREA_ID_SOURCE,
 sum(AMOUNT) as TOTAL_STOCK
  from STOCK_RECORDS
  where STOCK_RELEVANT = -1 and EDITDATE <= :EDITDATE   group by PRODUCTID, 
STORAGE_AREA_ID_SOURCE
)
That would apply to all rows. If I pass PRODUCTID and STORAGE_AREA_ID_SOURCE as 
parameters as well, that wouldn't be a full view of data to work with.
Where would I put the EDITDATE part, when using CTE?

Re: [firebird-support] Potential for improvements / optimization for the use case below?

[Lester Caine les...@lsces.uk [firebird-support]]

On 02/04/2020 08:12, Patrick Marten patrick_mar...@yahoo.com 
[firebird-support] wrote:
> There was an other procedure that took long, and I was able to 
> drasticaly improve it by adding one multi-segment index, but all my 
> attempts to do the same in the case above didn't have much impact so far.

Just a quick reply while passing ... CTE

https://firebirdsql.org/refdocs/langrefupd21-select.html#langrefupd21-select-cte
 
for example.

Use the 'with' section to produce a view of the data that you need to 
work with, and then the select section can include the 'sum' on the 
already filtered data.

I'm working with tables that are in the millions now but the reports are 
now as fast as they were when we only had tens of thousands ... I'm 
summing the current day or week from many years of live data.

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.uk/wiki/Contact
L.S.Caine Electronic Services - https://lsces.uk
Model Engineers Digital Workshop - https://medw.uk
Rainbow Digital Media - https://rainbowdigitalmedia.uk