Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 356347

Summary:

SQL Query Builder Add Table shows multiple DBO schemas for MS SQL Server

Product:

[Tools] Data Tools

Reporter:

scott_hathaway

Component:

Enablement

Assignee:

dtp.connectivity-inbox <dtp.connectivity-inbox>

Status:

CLOSED DUPLICATE

QA Contact:

Severity:

normal

Priority:

CC:

lchan

Version:

1.9

Target Milestone:

---

Hardware:

OS:

Windows 7

Whiteboard:

Attachments:

Description	Flags
Screen shot of add table dialog.	none

Description scott_hathaway

2011-08-31 10:47:23 EDT

Build Identifier: Eclipse 3.5.2 M20100211-1343, DTP 1.9.0.v201106031100-7I9O-FE9JfxmjWSl6tUWLp5J91_8

When adding a table to the SQL Query Builder using a MS SQL Server connection with the sqljdbc4.jar the Add Table dialog shows multiple DBO schemas and not database names. This makes it very hard to find a table that you want to add.

Reproducible: Always

Steps to Reproduce:
1. Create a DB connection to a SQL Server instance using the sqljdb4.jar.
2. Create a new .sql file and open the SQL Query Builder
3. Add a table to the builder.

The resulting dialog with show the problem.

Comment 1 scott_hathaway

2011-08-31 10:48:50 EDT

Created attachment 202531 [details]
Screen shot of add table dialog.

Comment 2 Linda Chan

2013-08-15 20:33:10 EDT


*** This bug has been marked as a duplicate of bug 348160 ***