#271 Timeout when connecting to SQL Server over VPN

[Ramsay Domloge]

When connecting to a MS SQL Server database over a VPN
connection, SQuirreL times out.

I conducted some simple tests and discovered that
connecting to an SQL Server database over a VPN, using
JDBC, takes a phenomenal amount of time - is it
possible that SQuirreL imposes and arbitary time-out
for connections?

I am using Windows XP with Java 1.4.2_08.

Not sure about the version of JDBC driver or SQL Server
database (can find out if you need it).

[Rob Manning]

Logged In: YES
user_id=1287991

Our company has a vpn and we use the cisco vpn client to
access it. I can connect to one of our internal database
servers just fine without
any perceptible delay.(It's not MS SQLServer, it's Sybase.
If you suspect a MSSQL + vpn issue, can you try a different
database?)
I'm using WinXP and Java 1.4.2_07. I would suspect that if
connection takes longer than what's allowed before timeout,
SQuirreL's performance would probably be pretty bad as well.
Might
want to try writing a small java app that simply connects
using your
jdbc driver and see how long that takes.(It might be a
java+jdbcdriver+MSSQL+vpnclient+vpnsetup issue and by
changing one of the variables, it might get corrected.)

Rob

[Ramsay Domloge]

Logged In: YES
user_id=593031

I can connect to Oracle, MySQL and MS SQL Server over my VPN
using JDBC with *other* tools. When connecting to the SQL
Server DB, it takes ages, but works eventually.

With SQuirreL, however, it times out.

I am using the Cisco VPN client (v4.0.4) on Windows XP.

[Gerd Wagner]

Logged In: YES
user_id=776065

Please adopt the login time out in SQuirreL's Global
Preferences to your needs.