We have a client who has a server and 6 workstations. They have a 7
user Advantage Database Server License. The server version is 8.1 as is
the Delphi components that we are using.
The problem is that when they open out program first thing in the
morning it will first connect Locally to the database (then of course
all the others will connect locally as well). But if they program is
opened on the server first (or frequently if the program is restarted on
the workstation) the connection will be made using a remote connection,
and all the workstations will then connect remotely.
There are no error messages and the workstations do not ~seem~ to have
any issue connected remotely. Nothing is being changed on the firewalls
or in the program or anything. It is becoming a pain for the client to
always have to run the program twice or run it on the server (especially
since the first people in do not have access to the server) so that they
can get the performance boost of using the Database Server.
Any ideas why this might be happening?
Insight Development Team
From: Trevor B <email@example.com>
User-Agent: Thunderbird 22.214.171.124 (Windows/20080421)
Subject: Connecting Remote Issues
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
X-Trace: 16 Jul 2008 09:22:10 -0700, 126.96.36.199
Xref: solutions.advantagedatabase.com Advantage.Networking:786
Article PK: 1132205
Subject: Re: Connecting Remote Issues
Content-Type: text/plain; charset=iso-8859-1
Date: 16 Jul 2008 15:35:09 -0700
X-Trace: 16 Jul 2008 15:35:09 -0700, 188.8.131.52
Xref: solutions.advantagedatabase.com Advantage.Networking:787
Article PK: 1132206
we recommend to use either ALS _or_ ADS/AIS in the
AdsConnection/AdsSettgins components, but not both at the same time.
The reason for that is exactly what you described.
If you need to support both types of servers with one application, use
an ini file or registry setting in your app to determine which
servertype to set at startup.
System Consultant (Advantage Database Server)