Squirrel 3.5.3 on windows 7 with jtds 1.3.1 is used to connect to MS SQL
10 with several databases on the same server using AD authentication,
connection string is
'jdbc:jtds:sqlserver://address:1433/db;;integratedSecurity=true;authenti
cationScheme=JavaKerberos'. The problem is that with this connection
string I can browse tables (i.e. expand <database>.<schema>.TABLE in the
objects pane) only of the database specified in the connection string,
others are empty, and if I don't specify database name there I cannot
browse tables at all. All tables of all databases are still accessible
in SQL queries but having to remember tables and fields by heart is
rather trying, creating individual aliases for each of the databases is
only a little better. Is it possible to browse tables of multiple
databases?
|