Subject | Re: [firebird-support] Embedded database with multiple users... |
---|---|
Author | Ann W. Harrison |
Post date | 2005-05-10T21:15:37Z |
WATYF wrote:
Firebird. The database can be opened with exactly one program. That
program can make lots of independent connections, but it cannot share
the database with another program. By design.
So, what are your alternatives? Either superserver or classic - both
handle multiple connections. They've got a bit more overhead than
embedded - an environmental variable to define, and a service or
application to start in the case of superserver. However, neither takes
much memory and both are reasonably small on disk.
Regards,
Ann
> Hello... I'm using the embedded version of FB with a .NET app thatUnfortunately, you've run into the essence of the embedded version of
> I've written. The app is part Windows Application and part Windows
> Service, so it needs to be able to hit the db with two simultaneous
> connections.
Firebird. The database can be opened with exactly one program. That
program can make lots of independent connections, but it cannot share
the database with another program. By design.
So, what are your alternatives? Either superserver or classic - both
handle multiple connections. They've got a bit more overhead than
embedded - an environmental variable to define, and a service or
application to start in the case of superserver. However, neither takes
much memory and both are reasonably small on disk.
Regards,
Ann