Hi there,

I'm having pretty much the same problem the original poster was
describing. I'm trying to configure an ODBC datasource from one host
to a firebird 1.5 database running on another host using the latest
(2.0) ODBC driver. When I test it, I get the same error message:
"Connection failed! File database is in use by another process.

The database is also being use by a client application written in
Delphi. I found that if I try the same to connect to a database which
has *NO* active user connections, it works just fine, but it never
works when there is an active connection. There are multiple instances
of the Delphi client connecting to the database at the same time, so I
can't imagine that any one of them has an exclusive lock.

It seems unlikely that it's impossible to open an ODBC connection to a
database which is also in use by a thick client. I played with the
selecting a "client" (the fbclient.dll), but this didn't help. I can't
find any other settings to try which might help.

Any more thoughts from anyone on this?

I hope my situation and question are clear. Sorry if I'm not providing
some necessary info or missing something obvious; I am a newbie to
Firebird (though not to RDBMS systems).

Regards,

Poney Carpenter



--- In firebird-support@yahoogroups.com, John Jaabæk <johnjaab@o...>
wrote:

> No change at all.
>
> On Sunday 20 March 2005 22:33, salisburyproject wrote:
> > Try removing the Client option. Leave this text box empty.
> >