Filebased connection to Databasefile on Networkshare

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
-ChrisE-
Posts: 17
Joined: Tue 22 Jun 2010 12:40

Filebased connection to Databasefile on Networkshare

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

Code: Select all

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-
Posts: 17
Joined: Tue 22 Jun 2010 12:40

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.

Post Reply