Subject | Firebird Embedded ADO + ODBC Simultaneous connections |
---|---|
Author | lucasjessee |
Post date | 2007-05-31T20:17:50Z |
Hi,
I'm working on a project that uses 2 separate connections to a
Firebird embedded database, within the SAME executable. One portion
of the project is using ADO to connect to Firebird, while the other is
using ODBC. Both are independently capable of connecting, but both
connections cannot exist at the same time. I am guessing this is
because the file is locked by the first connection. However, I've
seen marketing literature that claims one of the "features" of
Firebird is that you can connect to an embedded database multiple
times from the same application. Is this limited to the same
connection method (ADO, ODBC, etc)? Do you have any suggestions how I
can resolve this?
Thanks in advance,
Luke
I'm working on a project that uses 2 separate connections to a
Firebird embedded database, within the SAME executable. One portion
of the project is using ADO to connect to Firebird, while the other is
using ODBC. Both are independently capable of connecting, but both
connections cannot exist at the same time. I am guessing this is
because the file is locked by the first connection. However, I've
seen marketing literature that claims one of the "features" of
Firebird is that you can connect to an embedded database multiple
times from the same application. Is this limited to the same
connection method (ADO, ODBC, etc)? Do you have any suggestions how I
can resolve this?
Thanks in advance,
Luke