Firbird DB multiple connections problem using BDE+ODBC connection

21 views Asked by At

I have a set of applications working with InterBase databases. Now I try to migrate it to Firebird 4 instead.

I migrated the DB and installed Firebird ODBC driver (2.00.05.156) and set connection. BDE see this ODBC connection and an app could connect and work by BDE (via ODBC driver) successfully.

The issue is when I try to run another app (or second instance of the same app) that connecting to the same DB (also by BDE with ODBC driver) it's failed with error: "[ODBC Firebird Driver]File Database is not found".

In other words, it looks like only one BDE connection using the ODBC driver can be accepted to the same DB.

OS: Win10/Win11

I tried to change the parameter "safe thread" in Firebird ODBC driver - didn't help.

Is it possible to avoid this problem by keeping BDE usage (the apps are huge and it will be very difficult to replace the BDE)?

0

There are 0 answers