[Squirrel-sql-users] Error choosing MSSQL database

[Frank B. <fra...@eu...>]

Hi list,

I've a problem choosing a MSSQL 2000 database via the dropdown list. However 
the "use database;" command from the SQL worksheet works fine. The problem 
occurs with the jTDS and the MS SQL 2005 JDBC driver. The server gives me an 
error with SQLState 08004 and ErrorCode 911. With the MS SQL 2000 JDBC driver 
I get no errors but when I connect to the server SQuirrel complains about 
incompatibe JRE and JDBC versions. My java version is 1.6.0_03 and SQuirrel 
is 2.6.5.

Can I safely ignore the incompatibility and use the old jdbc driver or is 
there a possibility to use the new jdbc driver without the annoying "use 
database;"?

Many thanks
Frank