CannotSelectTablesFromMsSql2000BecauseItSaysNoPrimaryKeyNextToEachTableButTheTablesDOHaveAPrimaryKeyWhatDoIDo

1. Install the SQL Server JDBC driver at http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en

2. In NetBeans, go to the "Services" tab (next to "Projects" and "Files"), select "Databases" --> "Drivers", right-click and select "New Driver...".

3. Click "Add.." and find the SQL Server driver (path should be similar to "C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\"), and select all three files ("msbase.jar", "mssqlserver.jar", and "msutil.jar").

4. On any driver selection page, select "Microsoft SQL Server 2000 (Microsoft driver)" instead of the JDBC-ODBC bridge.

Not logged in. Log in, Register

By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo