Is it possible to update one Firebird database from a trigger in another Firebird database?

Question

I have two firebird databases running on one server, and I want to write to a table in one of the databases from a trigger in another database when certain actions occur. I had a search and I can’t find out if this is possible.

Can this be done natively in firebird or through UDF?

thanks

Neil

Answer 1

This is possible in Firebird 2.5 using the "on external" syntax. Example:

EXECUTE STATEMENT('insert into table(field) values(?)')(:Param) ON EXTERNAL 'another_server:C:\DB\DB.FDB' AS USER 'SYSDBA' PASSWORD 'masterkey';