Subject Re: [firebird-support] UNC to drive letter path
Author Martijn Tonies
Hi Thomas,

> I have encountered a rather enoying problem!
>
> I noticed that on Win32 platforms it is impossible to create or
communicate
> with a FireBird database (ver 1.0.3) on a remote machine when using the
UNC
> file path directly to connect to the database. For example: if the UNC
path
> to the server is \\server1\data\dir\database.gdb one instead must supply
the
> local drive letter path (in the form of e.g. server1:E:\dir\database.gdb).
> This by itself does not pose a problem, however, I found it impossible to
> extract from a given UNC path the drive letter on the remote machine.
I.e.,
> clearly one can catch the server name, but extracting that it is the "E:\"
> drive on the remote machine I found impossible to do?
>
> Does anybody know if it is possible to use a UNC path (maybe in a
different
> form than I have tried to) to connect to a Firebird database (using Delphi
> and the IBExpress package) or how one instead could find out the true
> logical drive path on a remote machine from a given UNC path?

I wonder: what has an UNC path - which is a share, right? - to do with
the local path and connecting to a database? A UCN path is a _client_
side thing, while a local path is a server side thing. Database files
should not reside in shared folders.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com