So there isn’t any locking at all
or only the locking of the filesystem where the file is located (like MS
Access is doing when putting a file on a network share)…
I just want to give it a try and
I know how risky this feature could be and I’m just curious why this is not
working since the firebird.conf clearly states:
“Applications that use the
"embedded" variant of Firebird and never share access to a database can use
this option to permit direct access to databases on NFS mounted
volumes.”
And that’s what I need but it’s
not working….
Daniel
what connection string are you
using?
if you make 2 simultaneous
connections to this file and make a write to it from either side, the file
will be corrupted beyond repair - try it on something which doesn't
matter.
If you don't need to share it
then you'd be better off connecting locally anyway. I don't see the point in
your experiment unless the file is so large that it won't reside locally and
the share is the only volume with enough space to house
it.
MSAccess is MS and makes one
giant assumption - it only ever resides on windows OS's. It's also
non-multigenerational and it's level of transaction control is completly
different - there is no real comparison between the two and what they
do.
Alan
-----Original
Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alan McDonald
Sent: Donnerstag, 10. August 2006
15:31
To: For users and developers of the
Firebird .NET providers
Subject: Re: [Firebird-net-provider] Use
"RemoteFileOpenAbility = 1"toaccessaembedded DB located on the
network?
Boolean parameter which, if set True, allows the
engine to open database files which reside on a networked filesystem (NFS)
mounted partition. Because the filesystem is beyond the control of the local
system, this is a very risky feature
that should not be enabled for the purpose of opening any
read/write database whose survival matters to you.
does it matter to you?
Alan
-----Original
Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Daniel Schwarz
Sent: Thursday, 10 August 2006 11:04
PM
To: For users and
developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider]
Use "RemoteFileOpenAbility = 1"toaccess aembedded DB located on the
network?
Hi
everybody,
I just
had the problem that it is not possible to access an embedded firebird
DB-file located on a shared network drive…
I
thought the “RemoteFileOpenAbility” is exactly what I need to do this –
but I get the error:
“I/O
error for file CreateFile (open) \"here comes the path” \r\nError while
trying to open file"} System.Exception
{FirebirdSql.Data.FirebirdClient.FbException}”
Any
idea why this happening? I have complete access to that folder (read and
write) on the network drive…
Thank
you!
Daniel
it's not
possible - embedded needs to make an exclusive lock on the file and that
can;t happen over network drives with unknown OS's at the other
side. Can;t be done -
if you want to share a db then use the full server
Alan
But what can I do with
the „RemoteFileOpenAbility” flag in
the firebird.conf file then? It seems to me that this is exactly what I
need to “override” the security issue and access the file or am I
wrong?
