Subject Re: [firebird-support] Re: Nbackup
Author Martijn Tonies
Hi,

> Just some unrelated questions that is bugging me and I didn't find
> right answer:
>
> 1. What is difference between database connection string "C:\MyDb.fdb"
> and "localhost:C:\MyDb.fdb", or in other words what is difference
> between 'direct access' and 'tcp' access?

The protocol of communication between the server and the client, it's
really not "direct" anyway, as all database access goes through the server.

> 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.

Yes.

> 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 (I'm using FireBird
> as superserver (as service) on Windows Server OS).

I've never heard of curruption issues, only a blocking issue but I think
that was solved before Firebird 1.0 hit the market.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Sybase
SQL Anywhere, Oracle & MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com