This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 144314 - DB tables not detected or shown
Summary: DB tables not detected or shown
Status: RESOLVED INVALID
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All Windows XP
: P2 blocker (vote)
Assignee: issues@ide
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-08-18 21:10 UTC by gannias
Modified: 2008-10-07 18:29 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
sceen shot of no tables list with data from the query (124.69 KB, text/plain)
2008-08-18 21:15 UTC, gannias 		Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description gannias 2008-08-18 21:10:37 UTC 
Connecting to a SQServer 2005 db with integrated security set to true. A connection is established but no tables are 
shown even though I can execute a query (execute command -> run statement) from the IDE and it returns the expected 
resultset.
Comment 1 gannias 2008-08-18 21:15:37 UTC 
Created attachment 67744 [details]
sceen shot of no tables list with data from the query
Comment 2 Jaromir Uhrik 2008-08-21 12:49:17 UTC 
Reassign to DB module.
Comment 3 David Vancouvering 2008-08-21 17:59:17 UTC 
Not a P1 as we don't support SQL Server 2005 driver - we give our best effort but it's not an officially supported
driver.  See http://wiki.netbeans.org/DatabasesAndDrivers.

As a workaround, please try the jTDS driver at http://jtds.sourceforge.net/ and let me know how that goes.

Marking incomplete for now until I hear whether this works for you as a workaround.

Thanks.
Comment 4 Andrei Badea 2008-08-21 18:19:12 UTC 
Perhaps the IDE is not displaying the right schema. When registering the connection, go to the Advanced tab and
experiment with the schemas. Especially try if selecting the "dbo" schema helps.
Comment 5 David Vancouvering 2008-10-07 18:29:07 UTC 
Haven't heard from gannias since Aug 18.  Closing