I have a java applet that connects to an ASA database using JConnect
3.0. When I run the applet on the same machine that the database is
running, JConnect takes an incredibly long time to get a connection.
Sometimes as much as 3 minutes. The weird thing is that I run dbsrv in
verbose mode and I can see the driver connect and interrogate the
database (perform some queries based on what the DB supports I
suppose). I am connecting to the DB using Tds and the database is
running only TCPIP. I don't think it can be a licensing problem
because I have 5 licenses and I am only using 1.
Now here's the kicker. If I run the applet on a machine that is not
running the database, I connect with no problem.
This is very puzzling......
Date: Wed, 21 Oct 1998 10:10:02 -0400
From: Chris Gow <firstname.lastname@example.org>
X-Mailer: Mozilla 4.05 [en] (WinNT; I)
Subject: Slow connection times using ASA 6.0 and JConnect 3.0
Content-Type: text/plain; charset=us-ascii
Xref: forums-1-dub sybase.public.jconnect30:373 sybase.public.sqlanywhere.general:395
Article PK: 255773
Subject: Re: Slow connection times using ASA 6.0 and JConnect 3.0
Date: Wed, 21 Oct 1998 10:32:09 -0400
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Xref: forums-1-dub sybase.public.jconnect30:372 sybase.public.sqlanywhere.general:394
Article PK: 255772
Try to make sure it is not a TCPIP/DNS configuration problem. Recode the
applet to connect to the IP address of your machine instead of it's name. If
this connect is fast, you have a TCP/DNS problem.