Subject Re: [firebird-support] Re: Read-only DB on a network share
Author Matthias Hanft
Helen Borrie wrote:
> SQL> connect r:\scratchme.fdb;
> Statement failed, SQLCODE = -902
> SQL> connect \\shorty\deskstar\scratchme.fdb;
> Statement failed, SQLCODE = -902

I think that those two commands cause ISQL try to setup
a) an IP connection to port 3050 of a DNS host called "r"
b) a NETBIOS session to SHORTY
each without touching the locally running FB server at all
(and expecting a FB server "on the other side").

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

You could try to use an alias. Write something like
scratchme = \\shorty\deskstar\scratchme.fdb
into your local aliases.conf and try "connect localhost:scratchme"
in ISQL. Of course, this only works if your local computer
has the ability to log into "shorty" without further credentials
- no way to ask the user for a username and/or password here.

And don't write
scratchme = R:\scratchme.fdb
because drive letter mappings only exist for the foreground user -
if FB runs as a service, it doesn't know at all about any remote
drive letters. (You could, maybe, succeed with "R:" when running
FB as an application.)

In any case, it's not _that_ simple... :-)