Hi,

> Can someone with better understanding of Embedded Firebird confirm or
> shoot down the notion that only one connection can ever be established
> to the Embedded Firebird database at any give time?

AFAIK One application (OS process) can establish arbitrary number of
connections. Two different applications cannot establish connections to
one database file simultaneously. Don't know about JayBird.

> I haven't been
> able to get multiple connections to the database and I not quite sure
> if I'm doing something wrong. I think I'm doing everything right
> and
> the readme file says:
>
> "You may run any number of applications with the embedded
> server without any conflicts. Having IB/FB server running
> is not a problem either.

You can run any number of applications (OS processes) with the fbembed
and even fbserver on one host without problem.

>
> But you should be aware that you cannot access single
> database from a number of the embedded servers
> simultaneously, because they have SuperServer architecture
> and hence exclusively lock attached databases."

Two (or more) different applications cannot establish connections to one
database file simultaneously.

>
> Can someone clarify this?

Is it became clearer ?

>
> We really want to use Firebird instead of Oracle Lite.

Don't give up :)

Good luck !