Search code examples
delphifirebirdinterbasefirebird-embedded

how to connect UNC-located database to embedded server?


I have next specific situation. I have an application using Firebird embedded server. The files: application executive, database, fbembed.dll are located in the same folder. Everything is good and working good.

Now my client says so:

I would like to place all your application file on a server and run it via local network from all workstations.

So as I see I start application on the server and it starts. But database connection string looks now like:

//SERVER/share/db.fdb

Yes, I know conventions about allowed firebird paths from here: FAQ: What's a connection string?

I do not understand what should I use with embedded server? Is it possible at all?


Solution

  • If you want to access a Firebird database over the network, then you need to install Firebird server and connect through the server. You can't (at least not by default) access a database from a network path, and you really shouldn't (although there is a config option to allow it), as it can lead to database corruption due to insufficient or incorrect filelocking support over the network.

    So: Don't use Firebird embedded, but install Firebird server and configure the clients to connect to Firebird server.