Subject Re: [firebird-support] Re: Nbackup
Author Dmitry Yemanov
Branimir Trumbic wrote:
>
> 1. What is difference between database connection string "C:\MyDb.fdb"
> and "localhost:C:\MyDb.fdb"

Different transport protocols (TCP and shared memory) are used.

> in other words what is difference between 'direct access' and 'tcp' access?

I'd say that 'direct access' is somewhat confusing term, as it could
mean three different things: (a) local access (aka XNET, aka shared
memory transport), (b) embedded access (no transport is involved) or (c)
OS file-level access to the database.

> 2. Can multiple database clients safely connect to the same database
> using direct access method ("C:\MyDb.fdb")? Under 'safely' I mean: no
> database corruption, deadlocks, transactions are safe, no multi thread
> problems or other problems that can be caused by concurrent database
> connections.

They definitely can, as long as you run the latest FB build of the v2.x
series.

> I was under impression that if more then ONE database client is using
> SAME database, that all connections must go through TCP layer
> (localhost or remote) to ensure database stability

This is wrong impression.


Dmitry