Subject Re: [firebird-support] Problem to open a database file from a Fileserver
Author Lucas Franzen
Gregor,


sifi24viper schrieb:
> Hello
>
> I have a QNAP TS-101 Fileserver, and i have moved all my projectfiles
> from my computer to this fileserver.
>
> Now the connection is over a Netzworkdrive "Z:" i have move also the
> registration for all my databasefilse. But when i try to open the
> database i got the follow error:
>
> Unable to complete network request to host "GK-TS101". Failed to
> etablish a connection. The System can not find the File.
>
> SQL Code: -902
> IB Error Number: 335544721
>
> After that in the Firebird Logfile is the follow entry:
>
> GK-DELL8300 (Client) Thu Apr 13 13:49:46 2006
> WNET/wnet_error: CreateFile errno = 2
>
> I have tryed serveral things:
> \\192.168.2.4\Projekte\Koenig\Prog\KOENIG.FDB
> \\GK-TS101\Projekte\Koenig\Prog\KOENIG.FDB
> Z:\Koenig\Prog\KOENIG.FDB
>
> I have tried FB 1.5.3 and also FB 2.0.0 RC1
>
> But nothing helped, i have also checked the Right's on the fileserver.
>
> I have no more idea, may sombody can help me!

the database has to be located on a LOCAL drive of the server.
You CANNOT put it on a network drive.

Furtheron there have to be NO permissions on the directory / file.

The client is NOT accessing the file - it is telling the server to do
so. So the server itself should have the appropriate permissions on the
file - that's it (which is also why you should install the firebird
server with an admin login).

So if your database is located on your server (let's call it
MY-SERVER-01) as: E:\Database\MyDatabase.fdb
then you have to connect from a client with the settings:

Server: MY-SERVER-01 (or the IP-adress)
Database: E:\Database\MyDatabase.fdb

That's all.


Luc.