Leonid,
I am still on 3.5.0 and I can Set Default Catalog on another database and refresh tree and cache, and it would fetch the objects.
Give it a try. Hopefully that would be a lesser inconvenience. It looks like Squirrel only fetches from default catalog.
Alex
From: Mironov, Leonid {BIS} [mailto:Leo...@pe...]
Sent: Thursday, August 21, 2014 6:05 AM
To: squ...@li...
Subject: [Squirrel-sql-users] cannot browse tables in multiple MS SQL databases
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;authenticationScheme=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?
|