Re: [firebird-support] Re: Firebird Embedded open database file on network share

[Ann Harrison aharri...@ibphoenix.com [firebird-support]]

 On Jan 22, 2015, at 5:06 AM, ralf.erdm...@web.de [firebird-support] 
 firebird-support@yahoogroups.com wrote:
 
 So I now know I had no good idea with the network share :-)

I hope I made that clear :-)
 
 I thought it possible because I read that firebird embedded is at most the 
 same engine as the firebird server.

It is.  But the Shared Server has a single process mediating all physical 
access to the database file and the Classic Server uses interprocess 
communication to avoid physical access conflicts.
The Embedded Engine mediates conflicts between connections it makes, but has no 
way to detect the existence of other Embedded Engines accessing the file 
through a network share.

Good luck,

Ann
 

Re: [firebird-support] Re: Firebird Embedded open database file on network share

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 22 Jan 2015 01:06:28 -0800, ralf.erdm...@web.de [firebird-support]
firebird-support@yahoogroups.com wrote:
 Thanks Ann.
 So I now know I had no good idea with the network share :-)
 
 I thought it possible because I read that firebird embedded is at most
the
 same engine as the firebird server.
 But obviously I didn't thought about such implications.

The engine is the same, and Firebird server would have the exact same
problem if you would attempt to let multiple Firebird server instances
access the same database from a network share.

If you want to access a Firebird database over a network, use a single
Firebird server instance.

Mark

Re: [firebird-support] Re: Firebird Embedded open database file on network share

[ralf.erdm...@web.de [firebird-support]]

Thanks Ann.
So I now know I had no good idea with the network share :-)

I thought it possible because I read that firebird embedded is at most the same 
engine as the firebird server.
But obviously I didn't thought about such implications.

Thanks to all who took time to help me,
Ralf

[firebird-support] Re: Firebird Embedded open database file on network share

[ralf.erdm...@web.de [firebird-support]]

Hi Elmar,
thanks for your answer.

Never worked with Config-Options so far.
Are all options set in the firebird.conf file?

When I started with firebird embedded I found many warnings that it can only 
handle one connection to a database. If I understood it right this was changed 
with version 2.5.x

Do you mean corruption will occur because firebird embedded can still handle 
only one connection at a time or is it because of the storage location of the 
file on a network share?

Kind greetings,
Ralf