Re: [Squirrel-sql-users] Tables missing from object tree for sybase

[Rowe, N. <Nev...@dk...>]

It should probably be an enhancement - it seems wrong to let you select a
database in the tree if the results for it aren't populated. Either
SquirrelSQL should cache results for all databases, or only allow you to
select the current database.

N.


On 3/12/08 16:10, "Job Evers" <job...@gm...> wrote:

> Rowe, Neville wrote:
>>>> On Tue, Dec 2, 2008 at 8:16 PM, Job Evers <job...@gm...>
>>>> wrote:
>>>>> I'm running Squirrel Sql 2.6.8 with jconnect-6.0 to connect to
>>>>> a sybase db.  As far as I can tell everything queries just
>>>>> fine. But, I cannot see any tables in the object browser.  It
>>>>> lists the different databases, and all the different users, but
>>>>> when I try to actually look at the tables, I get nothing.  If
>>>>> it means anything - sp_tables works just fine.
>>>>> 
>> 
>> Firstly the set of objects shown is only the objects in the current
>> database (catalog in SquirrelSQL terms). So if your default database
>> isn't the same as where your objects are then you won't see any.
> 
> Thanks.  I didn't realize this (or see it written anywhere).  Changing
> the current catalog got the results I wanted.



--
This e-mail is confidential and the information contained in it may be privileged.  It should not be read, copied or used by anyone other than the intended recipient.  If you have received it in error, please contact the sender immediately by telephoning +44 (0)20 7623 8000 or by return email, and delete the e-mail and do not disclose its contents to any person.  We believe, but do not warrant, that this e-mail and any attachments are virus free, but you must take full responsibility for virus checking.  Please refer to http://www.dresdnerkleinwort.com/disc/email/ and read our e-mail disclaimer statement and monitoring policy.

Dresdner Kleinwort is the trading name of the investment banking division of Dresdner Bank AG, and operates through Dresdner Bank AG, Dresdner Kleinwort Limited and their affiliated or associated companies. Dresdner Bank AG is a company incorporated in Germany with limited liability and registered in England (registered no. FC007638, place of business 30 Gresham Street, London EC2V 7PG), and is authorised by the German Federal Financial Supervisory Authority and authorised and subject to limited regulation by the Financial Services Authority ("FSA"). Details about the extent of our authorisation and regulation by the FSA are available from us on request.  Dresdner Kleinwort Limited is a company incorporated in England (registered no. 551334, registered office 30 Gresham Street, London EC2V 7PG), and is authorised and regulated by the FSA. 
--