RE: [Squirrel-sql-users] failed on MSSQL JDBC driver
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Arthur G. <ag...@ya...> - 2001-12-28 17:00:24
|
Thanks, Col. It worked after the login timeout set to zero. FYI: JDK 1.3.1 and SQL2000 Server are used. Happy New Year!!! Arthur -----Original Message----- From: Colin Bell [mailto:Col...@as...] Sent: Thursday, December 27, 2001 5:49 PM To: 'ag...@ya...'; squ...@li... Subject: RE: [Squirrel-sql-users] failed on MSSQL JDBC driver 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 _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com |