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 160269

Summary: SQL Server 2005 JDBC has Problems
Product: db Reporter: compucoder <compucoder>
Component: Show DataAssignee: Jiri Rechtacek <jrechtacek>
Status: RESOLVED DUPLICATE    
Severity: blocker    
Priority: P3    
Version: 6.x   
Hardware: All   
OS: All   
Issue Type: DEFECT Exception Reporter:

Description compucoder 2009-03-13 17:01:08 UTC 
When using the SQL Server 2005 JDBC driver from Microsoft (1.2) the NB IDE doesn't work with it well. If you don't
specify a DB on the connection resource you are stuck in master and the option to set default schema is always grayed out.

It is also not smart enough to insert the DB name into the query when choosing View Data. It should add the Db name
before the owner. i.e. dbName.dbo.users. If the default schema option actually worked then this isn't necessary. It may
be safest though to put it in by default anyways.
Comment 1 Jiri Rechtacek 2009-07-29 15:43:46 UTC 
Fixed in core-main/rev/f06457e60c13

*** This issue has been marked as a duplicate of 166549 ***