Foreign Key creation problem

Hello Friends,

I have a problem with Firebird Database.

If any Firebird database is opened using DBTools (IBACCESS,IBSQL etc.) or using ADO in one system, it is not able to create a table with foreign key reference from another system.
It is a great problem when we are using in Multi-user environment that we have close all the connections, then only we can create foreign key references.

If anyone know/found solution, please reply ASAP

Thanks

Suresh

There is no solution -- this is by design. Metadata changes should be done while no-one is connected.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
Upscene Productions
http://www.upscene.com

Hi ,

Even I faced the same problem. Then I debugged the code and commented out where firebird gets exclusive DB connection. Now I was able to create FK with multiple connection.

In Firebird-Architect forum I have discussed this. It seems that exclusive connection is needed for classic server and not for super server.

For details refer

Yahoogroups -- > Firebird-Architect --> search for mail with subject "Modified code - multi connection Meta data update".


BTW I strongly feel this as an issue in firebird. In many modern application there is a need to create table with FK in multi connection scenario.

In the "files" section of Firebird-Architect group I have uploaded my modified source (dfw.cpp),

S.Karthick