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.

Bizarre Connection Issues

2 posts in Networking Last posting was on 2008-09-25 14:02:48.0Z
Trevor B Posted on 2008-09-23 16:49:30.0Z
Date: Tue, 23 Sep 2008 10:49:30 -0600
From: Trevor B <trevb@salon-software.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: Bizarre Connection Issues
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 142.179.209.192
Message-ID: <48d91ca4@solutions.advantagedatabase.com>
X-Trace: 23 Sep 2008 10:43:16 -0700, 142.179.209.192
Lines: 28
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!142.179.209.192
Xref: solutions.advantagedatabase.com Advantage.Networking:810
Article PK: 1132229

Hi again all,

We have a client that has an interesting problem when trying to connect
to his ADS running on his server. Only about every second connection
will successfully connect to the DB.

We will run our program on a workstation while I watch the server
(currently no one has open connections) and it will work.

The second workstation will run our program and most often there will be
no connection made, so our program will switch to local mode and try
again, which of course fails. Then we will close our program and run it
again, usually it connects properly to the db server at this point. If
we close the program again and open it, we are back to it usually not
connecting.

The first workstation is idle during this test.

We have not been using ADS.ini to determine the connection type because
the location of the connection can be changed at any time and so we are
just using a path rather than an alias. We do try to connect remote
only first, and then if that fails we try local only.

Any help would be appreciated. Still not sure why it seems we have more
difficulty with our clients connecting than anyone else.

Thanks in advance,
Trevor B


Edgar Sherman Posted on 2008-09-25 14:02:48.0Z
Date: Thu, 25 Sep 2008 08:02:48 -0600
From: Edgar Sherman <no@email.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: Re: Bizarre Connection Issues
References: <48d91ca4@solutions.advantagedatabase.com>
In-Reply-To: <48d91ca4@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.24.34.164
Message-ID: <48db9887@solutions.advantagedatabase.com>
X-Trace: 25 Sep 2008 07:56:23 -0700, 10.24.34.164
Lines: 52
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.34.164
Xref: solutions.advantagedatabase.com Advantage.Networking:811
Article PK: 1132231

What is the error you receive when trying to connect with Remote. This
error will help you in determining the cause.

Most likely the error is a 6420. This error is covered in detail on the
Knowledge Base.

I would also recommend setting up an ADS.ini file and adding in the
following three lines (Replace anything in <> with the actual value
[<SERVERNAME>]
LAN_IP=<192.168.1.5>
LAN_PORT=<6262>

When not passing the port via the connection string or using this
setting in the ads.ini file Advantage will use Discovery to attempt to
find the server. Depending on the network, location between the two
machines, and a number of other factors discovery may fail. By adding
this setting you by-pass discovery and make a direct connection to the
server. If this fails then something is blocking the traffic most
likely or possibly network packets are being fragmented/corrupted on the
network.

Edgar

Trevor B wrote:
> Hi again all,
>
> We have a client that has an interesting problem when trying to connect
> to his ADS running on his server. Only about every second connection
> will successfully connect to the DB.
>
> We will run our program on a workstation while I watch the server
> (currently no one has open connections) and it will work.
>
> The second workstation will run our program and most often there will be
> no connection made, so our program will switch to local mode and try
> again, which of course fails. Then we will close our program and run it
> again, usually it connects properly to the db server at this point. If
> we close the program again and open it, we are back to it usually not
> connecting.
>
> The first workstation is idle during this test.
>
> We have not been using ADS.ini to determine the connection type because
> the location of the connection can be changed at any time and so we are
> just using a path rather than an alias. We do try to connect remote
> only first, and then if that fails we try local only.
>
> Any help would be appreciated. Still not sure why it seems we have more
> difficulty with our clients connecting than anyone else.
>
> Thanks in advance,
> Trevor B