Subject | Re: [firebird-support] Re: Read-only DB on a network share |
---|---|
Author | Helen Borrie |
Post date | 2008-04-21T23:02:37Z |
At 12:46 AM 22/04/2008, you wrote:
Volume in drive R is DESKSTAR
Volume Serial Number is D8FF-E103
Directory of R:\
22/02/2005 05:51p <DIR> Software
22/02/2005 05:51p <DIR> Programs
15/03/2005 11:18p <DIR> data
03/04/2005 02:19p <DIR> projects
04/03/2007 11:38p <DIR> Backups
19/04/2007 10:40a <DIR> adhocstuff
22/04/2008 07:35a 3,227,648 scratchme.FDB
1 File(s) 3,227,648 bytes
7 Dir(s) 18,664,423,424 bytes free
c:\Program Files\Firebird\Firebird_1_5\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect r:\scratchme.fdb;
Statement failed, SQLCODE = -902
Unable to complete network request to host "Shorty".
-Failed to establish a connection.
-The system cannot find the file specified.
SQL> connect \\shorty\deskstar\scratchme.fdb;
Statement failed, SQLCODE = -902
Unable to complete network request to host "shorty".
-Failed to establish a connection.
-The system cannot find the file specified.
SQL>
Meaning...I think...that the Y-valve is resolving the mapping to a straight network address and is reporting that it can't find a Firebird server there - not what we are trying to achieve. So - RemoteFileOpenAbility seems to be unavailable on a Windows network. Probably only works on NFS. Sorry to raise your hopes. Back to the flashdrive... ;-)
./heLen
>> >but in Message #93483 Helen writes:No clue. :-) Except I can confirm it doesn't work for a Windows server. Firebird server is running on Dev. Scratchme.fdb is a read_only database located on a mapped drive R: on Shortyc:\Program Files\Firebird\Firebird_1_5\bin>dir r:
>> >There is a config parameter allowing a database to be on a network
>> >device. (...)
>>
>> Ok so you've set your db to READ-ONLY (using gfix, for eg.) and
>uncommented
>> and changed parameter "RemoteFileOpenAbility" to "1" at
>firebird.conf and
>> still didn't work?!
>
>Unfortunately it still doesn't work with this Settings.
>>
>> Maybe Helen has some glue about it,
Volume in drive R is DESKSTAR
Volume Serial Number is D8FF-E103
Directory of R:\
22/02/2005 05:51p <DIR> Software
22/02/2005 05:51p <DIR> Programs
15/03/2005 11:18p <DIR> data
03/04/2005 02:19p <DIR> projects
04/03/2007 11:38p <DIR> Backups
19/04/2007 10:40a <DIR> adhocstuff
22/04/2008 07:35a 3,227,648 scratchme.FDB
1 File(s) 3,227,648 bytes
7 Dir(s) 18,664,423,424 bytes free
c:\Program Files\Firebird\Firebird_1_5\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect r:\scratchme.fdb;
Statement failed, SQLCODE = -902
Unable to complete network request to host "Shorty".
-Failed to establish a connection.
-The system cannot find the file specified.
SQL> connect \\shorty\deskstar\scratchme.fdb;
Statement failed, SQLCODE = -902
Unable to complete network request to host "shorty".
-Failed to establish a connection.
-The system cannot find the file specified.
SQL>
Meaning...I think...that the Y-valve is resolving the mapping to a straight network address and is reporting that it can't find a Firebird server there - not what we are trying to achieve. So - RemoteFileOpenAbility seems to be unavailable on a Windows network. Probably only works on NFS. Sorry to raise your hopes. Back to the flashdrive... ;-)
./heLen