Tobias wrote:

> my application depends on the database file being locked and only accessible by one process. It relies on an error being triggered when multiple processes try to open the same database. That way, it prevents the same kind of job from being run multiple times in parallel.
>
> Is there a way to get the file locking back,

Use the 2.1 Embedded Server, or any regular Superserver. If that's not an option...

> or what is the recommended way to prevent more than 1 database connection?

Write an ON CONNECT trigger which raises an exception if there is already an active connection.

BTW, even Superserver (embedded or not) doesn't prevent multiple connections.


Paul Vinkenoog