|
From: Colin B. <Col...@as...> - 2001-12-27 22:35:31
|
We've successfully connected to MSSQL (Version 7.0?) using the WebLogic drivers quite happily and the JDBC/ODBC bridge with some problems but never had a time out message. However it hasn't (as far as I know) been used with MSSQL 2000 or the MS JDBC driver. As the driver is a fairly new one I would suspect a problem with it. Two things you can try. First lets get some more info from the log. To do this you need to edit the preferences file prefs.xml after you've shutdown Squirrel. For NT it can be found in \WINNT\Profiles\<USER_NAME>\.squirrel-sql and for Win2000 its something like \Documents and Settings\<USER_NAME>\.squirrel-sql. Replace the line <debugMode>false</debugMode> with <debugMode>true</debugMode> The stack trace should be written to the file squirrel-sql.log in the same folder as your preferences file. Secondly you can turn on JDBC debugging by replacing <debugJdbc>false</debugJdbc> with <debugJdbc>true</debugJdbc> This will write whatever debug information is generated by the driver to standard output. Hopefully We'll get some more information about your problem. 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 |
