My Delphi 7 application is using Firebird 2.0.4 Super Server run as a
service. FIBPlus 6.4.1 components are used to connect to the Firebird
databases. Everything works fine when using the local machine
databases (on XP or Vista OS computers).
I can also access the Firebird databases on another client machine
(networked via office router), using TCP/IP connection strings, e.g.
client2:C\..\Data\databasename.fdb
In this last case, it is required for the Firebird server to be
installed and running on the client2 machine. Both the local machine
and the networked (client2) machine have the RemoteServicePort set to
3051 in the firebird.conf, with the FB library accessed from
C:\Program Files\Firebird\Firebird_2_0\bin\fbclient.dll on both
workstations.

However, if the back end FDB database is placed on the MS Small
Business Server (SBS) (with Firebird server installed and running on
that office server), it is not possible to access this remote
database. The server directory containing the FDB data has full
network share enabled (accessible from the workstation) and the folder
containing FB server installation is also shared. Installing the FB
server on the SBS server machine in C:\program files\... directory or
on some other shared D: drive makes no difference.
The connection fails when executing (FIBPlus component) command:
isc_res:=Call(FClientLibrary.isc_attach_database(SV, length(FDBName),
PChar(FDBName), @FHandle,FDPBLength, FDPB), False);

What needs to be done to enable this remote connection ?

Thank you for your help.

Regards,
Mario

P.S. Why it is necessary to run the FB server on the remote/server
computer when opening the remote back end database, instead of using
the Firebird service run on the local workstation machine, i.e. from
which the front end application is being run ?