Filebased connection to Databasefile on Networkshare

-ChrisE- · Post by **-ChrisE-** » Mon 04 Apr 2011 13:17

Hello,

IBDAC V 3.50.0.21
Firebird 2.5.0 Emb (without installation)

I try to connect to an Databasefile directly

IBCConnection.Server := '';
IBCConnection.Database := 'D:\DBs\testdb.db';

When I call connect (after solving this http://www.devart.com/forums/viewtopic.php?t=20559), everything works fine.

But when I set the Database-Porperty to an File on an Networkdrive e.g. Z:\testdb.db I got this Error:

Unable to complete network request to host "SERVER".
Failed to establish a connection.

where SERVER is the Networkshare-Provider.

Do you have any idea what's wrong in this code. Server-Property is blank.

Thanks for help.

Chris

-ChrisE- · Post by **-ChrisE-** » Tue 05 Apr 2011 06:59

Hello,

ok. I know what's wrong

It is not possible in Firebird to access an db on an volumen that is not owned by the maschine where the process is runnig.

But when you use Firebird 2.5 you are able to set an parameter in the firebird.conf to do this.
It's extrem risky to do this - see the comments in firebird.conf for the parameter.

RemoteFileOpenAbility

I think there should be an way with extrem careful programming to access the db with this parameter.

Thats all.

Best regards,

Chris

AndreyZ · Post by **AndreyZ** » Tue 05 Apr 2011 08:20

Hello,

It is good to see that you've found the answer. There is always a risk of database corruption when it's on a network drive, and comments in the firebird.conf file confirm this.