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

[Arthur G. <ag...@ya...>]

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