RE: [Squirrel-sql-users] failed on MSSQL JDBC driver

[Colin B. <Col...@as...>]

It seems that there is a known problem with the MS JDBC drivers
DriverManager.setLoginTimeout() method and some VMs (including the Sun 1.3.1
vm). One suggestion from the newsgroup is to set the login timeout to zero
(you can do this through the Global SQL tab in the Global Preferences
dialog).

If that doesn't work you can try the 1.2.2 JDK from Sun. Apparently it works
with that one.

You can get some more info from:

http://groups.google.com/groups?q=timed+out&hl=en&btnG=Google+Search&meta=gr
oup%3Dmicrosoft.public.sqlserver.jdbcdriver

Col


-----Original Message-----
From: Arthur Gong [mailto:ag...@ya...]
Sent: Friday, 28 December 2001 8:00
To: squ...@li...
Subject: [Squirrel-sql-users] failed on MSSQL JDBC driver


I am trying to use Squirrel SQL client against MSSQL. I added new driver in
and an alias (using the driver name and URL below). I used the same
user/password (test1, test1) to connect to the alias. An error dialog popped
up with message "Unable to open SQL Connection: [Microsoft][SQLServer JDBC
Driver]Login has timed out.".

I ruled out the possibility of failures in MSSQL JDBC drivers and server
itself by running following codes successfully against the driver and
server.

 String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
 String protocol =
"jdbc:microsoft:sqlserver://OOP2K:1433;DatabaseName=testdb";
  Class.forName(driver);
  Connection connection = DriverManager.getConnection(protocol, "test1",
"test1");

I tried to dig out some info from the log. Not much there. Wondering if you
ran into it too. Any suggestions?

Thanks.

Arthur


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users