|Subject||Re: [firebird-support] Cannot Connect to FireBird Database from network workstation|
Sunday, November 22, 2015, 8:07:49 AM, you wrote:
Back story: We had a custom designed program created in Delphi (I believe) that runs off of a Firebird database backend. This is the backbone of our business that tracks all work/inventory etc… for the company. Currently it is running on old hardware with FirebirdCS 2.1 on an older release of Fedora. Three Windows 7 machines connect to the database through the custom program. I have built a new Ubuntu server running Firebird Classic 2.5 to be the new server and have copied over the database and am hitting a wall on getting the program to connect over the network.
Production system running Ubuntu 14.04 (64Bit) and Firebird Classic 2.5 has the database setup and also has two samba file shares setup. The Windows 7 machine can see the shares (including the location of the database) but the program test connection is always unable to connect to the database. I also cannot connect to the Database from a remote machine using FlameRobin.
Therein lies your problem. Firebird won't connect to databases that are located on network shares. You must locate them on physical partitions that are under the direct control of the host server.
As a note, it is *possible* to configure Firebird to connect to a share but DO NOT DO IT.
Also, although Fb 2.5 will attach clients to a database created under 2.1, it is strongly recommended that you upgrade your databases to run under the higher server, in order to make the new features available. The On-Disk Structure (ODS) of databases changes with a major release. V.2.1 creates dbs of ODS 11.1, V.2.5 ODS 11.2. The way to migrate the databases is to back them up with gbak under the 2.1 server and restore the backup under the 2.5 server. Also make sure that your client machines have the latest client library, correct for the "bitness" of the application program.