Thread: [Squirrel-sql-users] sqlserver and objects
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Christian G. <chr...@ho...> - 2007-05-09 13:10:32
|
Hi, lately I've been working on sqlserver, no problem when querying tables through the SQL tab. However I'd like to browse the SYSTEM TABLE, TABLE, VIEW, PROCEDURE, UDT but nothing shows. Any ideas of where I can start to solve the problem ? driver: latest version of jtds driver. latest version of squirrel. thanks, Christian _________________________________________________________________ Windows Live Hotmail. Even hotter than before. Get a better look now. www.newhotmail.ca?icid=WLHMENCA148 |
From: Robert M. <rob...@gm...> - 2007-05-09 21:48:54
|
There should be a catalog drop-down at the top of the session window. Choose a catalog to which you have access and database objects live. Rob On 5/9/07, Christian Gosselin <chr...@ho...> wrote: > Hi, > lately I've been working on sqlserver, no problem when querying tables > through the SQL tab. However I'd like to browse the SYSTEM TABLE, TABLE, > VIEW, PROCEDURE, UDT but nothing shows. Any ideas of where I can start to > solve the problem ? > > driver: latest version of jtds driver. > latest version of squirrel. > > thanks, > Christian > > _________________________________________________________________ > Windows Live Hotmail. Even hotter than before. Get a better look now. > www.newhotmail.ca?icid=WLHMENCA148 > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
From: Robert M. <rob...@gm...> - 2007-05-11 00:13:47
|
On 5/10/07, Christian Gosselin <chr...@ho...> wrote: > I should have specified that I selected a catalog and that I don't see any > errors in the logs, even if I enable jdbc debug options > > Could it be that my sqlserver is not allowed to browse those objects ? > That would certainly be strange given that you can query them fine. Are you looking under the "dbo" node, which is under your catalog in the tree? Rob |