Thank you for the reply We use an application called Ascent, which is used to analyze vibration data from industrial machines. It stores its data in .fdb files. These files can either be on the local machine, or on a network share.
The application requires Firebird to be installed and running on both the client computer (which also runs Firebird client), and the server with the shared .fdb databases. Firebird is fully integrated with the Ascent program.. The only reason for the shared directory on the server, is to have a central repository for the .fdb files (as in an office environment). When using the program to access a database on the server, it includes a connection utility as per below: [cid:image001.jpg@01D5B4B3.9D14CF30] Just wanted to clarify that it’s not just a simple “accessing .fdb files via a network share”. The Ascent program is designed natively to work with Firebird. Again—I’m not a Firebird expert. But did want to give some idea of what we (and the application) are using it for. We were using this program with shared databases on a Windows 7 computer for years with no problems. The problems started happening when we upgraded to Windows 10. The Ascent program we are using is an older program, and rather specialized.. The support for it is dwindling. I talked to their support people, and they don’t seem too knowledgeable about Firebird. That’s why I sought-out a Firebird support group, in hopes of maybe getting some advice. From: firebird-support@yahoogroups.com [mailto:firebird-supp...@yahoogroups..com] Sent: Tuesday, December 17, 2019 7:39 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] When opening an .FDB file, Firebird says the database is already open by the same computer On 2019-12-16 22:00, David Wurdeman david.wurde...@mvpmt.com [firebird-support] wrote: > We have an application that uses Firebird to open .FDB databases, that > are stored on a shared directory on a server. Database should be 'shared' through a Firebird server instance. Users connect to the database through the Firebird server. What you seem to be doing right now is probably using Firebird Embedded (or locally hosted Firebird server instances) to access database through a shared directory. You should not perform concurrent access to a database through a shared directory, as it is a great way to corrupt things. > When we open a database with the app, there's a message that says: > > “COMPUTER XXX.XXX.XXX.XXX :XXXXX” > > “THE SIMULTANEOUS EDITING OF ONE DATABASE BY MULTIPLE USERS MAY > RESULT IN DATABASE ERROR MESSAGES, BUT WON’T CAUSE LOSS OF DATA. > CONTINUE?” > > We can click past the message and still get into the data. > > The IP address in the first line is the IP address of the computer > accessing the database. > > I'm assuming this message is coming from the Firebird server. > > The server is a Windows 10 pc, as is the client. The server is > running Firebird 2.5, and the client v2.1. > > Any ideas on what is causing this? Thanks for any advice! It is not a message from Firebird, so it is probably logic that is part of your software. Mark [Non-text portions of this message have been removed]
