Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Connecting Remote Issues

2 posts in Networking Last posting was on 2008-07-16 22:35:09.0Z
Trevor B Posted on 2008-07-16 15:28:10.0Z
Date: Wed, 16 Jul 2008 09:28:10 -0600
From: Trevor B <trevb@salon-software.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: Connecting Remote Issues
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 142.179.209.192
Message-ID: <487e1222@solutions.advantagedatabase.com>
X-Trace: 16 Jul 2008 09:22:10 -0700, 142.179.209.192
Lines: 25
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!142.179.209.192
Xref: solutions.advantagedatabase.com Advantage.Networking:786
Article PK: 1132205

Hi,

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?

Regards,
Trevor
Insight Development Team


Joachim Duerr (ADS) Posted on 2008-07-16 22:35:09.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Connecting Remote Issues
Newsgroups: Advantage.Networking
References: <487e1222@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.9
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 93.130.89.204
Message-ID: <487e698d@solutions.advantagedatabase.com>
Date: 16 Jul 2008 15:35:09 -0700
X-Trace: 16 Jul 2008 15:35:09 -0700, 93.130.89.204
Lines: 21
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!93.130.89.204
Xref: solutions.advantagedatabase.com Advantage.Networking:787
Article PK: 1132206


Trevor B wrote in <487e1222@solutions.advantagedatabase.com>:

> 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.

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.

--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com