Hello Ann,



I am not 100% sure that I fully understood your message. Emils question seem to be very similar to mine, only he uses Linux to run Firebird. I read your answer to Emil that it is ok and safe.



The share Z:\mysharedfolder\mydb.fdb is a folder on fileserver with the Firebird Server itself on it. Accessing the database via myhost:mydb points to the same file as Z:\mysharedfolder\mydb.fdb.



In my test I saw that a new record in both clients, independent which one created it.



I see also both users with following statement: select * from MON$ATTACHMENTS; One shows TCP/IP, the other one XNET.



Is it safe to use (read + write) the very same fdb file via TCPIP (access via myhost:myalias) and at the very same time to use it via XNET (access to the file with shared folder in the windows network)?



Thanks



Niko



Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Sonntag, 22. März 2015 19:12
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Connect via TCP and shared file parallel

On Mar 22, 2015, at 7:01 AM, 'Parzival' parzival1969@... <mailto:parzival1969@...> [firebird-support] <firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com> > wrote:

I am running Firebird 2.5.0 on Windows for some time on several customer locations. When the client and the server are in the same network the performance is good. It gets difficult when a more complex network structure (eg. Access via VPN) is in place. I see then error 10054 in the firebird.log and the client needs a lot of time to read data form the database.



I can't help you with that, though others on the list may have suggestions.





Searching for solutions I understand the the root cause of the error 10054 is on the network level. In the case the current network setup needs to remain unchanged I consider to access the firebird DB via a shared file:

Using Z:\mysharedfolder\mydb.fdb instead of remotehost:myalias

A s far as I have tested it this works also when some clients access via TCP and others via the file. Are there any known problems or gotchas on that approach?



Yes. Unless there is a managing Firebird server or a set of cooperating internet servers running on one machine, there's no coordination between client changes. The database will rapidly become corrupt. If your tests were read only or single client, you may not have seen corruption. Continue and you will. (See previous message.)



Good luck,





Ann









[Non-text portions of this message have been removed]