[Matthew H. Wagner]

I have successfully made a connection to a MS SQL Server but but cannot see any tables. When I expand a particular schema, the tree shows the SYSTEM TABLE, TABLE, VIEW, PROCEDURE, FUNCTION, TRIGGER entries but attempting to expand any of them produces no results. My installation details are pasted below.

*** Date:
Monday, April 27, 2009 3:41:29 PM EDT

** System properties:
OS=WindowsXP
OS version=5.1.0
Java version=1.5.0_11

*** MyEclipse details:
MyEclipse Enterprise Workbench
Version: 7.1.1
Build id: 7.1.1-20090310

*** Eclipse details:
MyEclipse Enterprise Workbench

Version: 7.1.1
Build id: 7.1.1-20090310

Eclipse Platform

Version: 3.4.1.r341_v20080731-9I96EiDElYevwz-p1bP5z-NlAaP7vtX6Utotqsu
Build id: M20080911-1700

Eclipse Java Development Tools

Version: 3.4.1.r341_v20080709-0800-7o7tEAfEF_U5qyUgrb2HAp539P97
Build id: M20080709-0800

Eclipse Graphical Editing Framework GEF

Version: 3.4.1.v20080806-67718083A56B4H2A3213573
Build id: 200809101400

Eclipse RCP

Version: 3.4.100.r341_v20080814-989JESIEdAciFYfkZZsBfSwQ2341
Build id: M20080703-0800

Eclipse Plug-in Development Environment

Version: 3.4.1.r341_v20080731-7T7U0E9mlRIuGUYviF_VP
Build id: M20080703-0800

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-showsplash
-launcher
C:\Program Files\Genuitec\MyEclipse 7.1\myeclipse.exe
-name
Myeclipse
–launcher.library
C:\Program Files\Genuitec\MyEclipse 7.1\../Common\plugins\org.eclipse.equinox.launcher.win32.win32.x86_1.0.101.R34x_v20080731\eclipse_1115.dll
-startup
C:\Program Files\Genuitec\MyEclipse 7.1\../Common\plugins\org.eclipse.equinox.launcher_1.0.101.R34x_v20080819.jar
-clean
-configuration
configuration
-vm
C:\Program Files\Genuitec\Common\binary\com.sun.java.jre.win32.x86_1.5.0.011\bin\client\jvm.dll

[Matthew H. Wagner]

Operator error. The DB explorer definitely has a unique view of the MS SQLServer DBs, but everything is there.

[Loyal Water]

This seems like a driver related problem. What driver are you working with and what version of the driver are you working with?

[Matthew H. Wagner]

I tried both the latest MS driver and the jTDS driver (from the FAQ) and experienced the same results. There are some differences between the tree view between MS SQL Server Management Studio and the Hibernate/DB Explorer, but everything is available in either case. I’ll post a screen shot of each tomorrow.

[Matthew H. Wagner]

Here are some screen shots of what I am seeing in the DB Explorer as well as what I am seeing in MS SQL Managment Studio. I am recording these here for my sake, as well as anyone else who gets confused in the hopes that they can avoid a similarly bone-headed post.

Shows DBs as seen from MS SQL Management Studio

Shows expanded view of tables

The DBs as seen from DB Explorer

The tables as seen from DB Explorer

” alt=””>

[support-joy]

siliconsmiley,
Thank you for uploading the screenshots. I guess the tables are displayed differently but all the information that you need is available in the DB explorer as well.

[Author]

Posts