Hi Thomas,

the easiest way to remove this restriction is to change the function
ISC_extract_host in isc_file.cpp so that it always returns
ISC_PROTOCOL_LOCAL, regardless of the input parameters. This makes Firebird
think that all given database file names are local. Works like charm as long
as you ensure that database files are not accessed by two processes on the
same or on different machines at the same time.

PS: Keep in mind that you have to switch the database file to read-only
mode. This is not done automatically.

Stefan Schultze

http://www.mailstore.com


--
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Clarke, Thomas (UK)
Sent: Donnerstag, 3. September 2009 18:11
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Database files on a remote mapped drive
development

 
Hi all,
I'm new to Firebird so please forgive me if I appear naive in any way.
I have been charged by my company to modify if necessary Firebird 2 so
that we ma be able to access database files on the network.
The safety issues listed wherever the issue is discussed (ie. the
database gettting corrupted under such circumstances) would not seem to
apply as there will be no writing to the database. It's purely read
only.
I tried to active RemoteFileOpenAbility in Firebird.conf but that did
not help.
I am therefore forced to consider modifying the source of the
application.
I would greatly appreciate it if anyone out there could give me a few
pointers to help me on my way.

BTW: I'm working on a Windows XP box with VS.NET and 2005 installed.
One of the main obstacles I've found is that there seems to be no easy
way to step through the code in debug mode in Visual Studio.
Do you know a way to set this up?


Thomas Clarke

trilogi Development Senior Analyst Developer

Email: thomas.clarke@...
<mailto:thomas.clarke@...>

Tel: (0117) 918 8879

Fax. (0117) 918 8043

Aerosystems International Limited
Registered Office: Lupin Way, Alvington, Yeovil, Somerset, BA22 8UZ, UK
Registered in England & Wales No: 1001553

********************************************************************
This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender.
You should not copy it or use it for any purpose nor disclose or
distribute its contents to any other person.
********************************************************************