- Get and install the Microsoft SQL Server JDBC driver OR the opensource jtds driver (libjtds-java in Synaptic Package Manager)
- Start up NetBeans
- Menu -> Window -> Services (or CTRL-5)
- Expand "Databases"
- Right-click on Drivers and select "New Driver"
- Click "Add..." in the "New JDBC Driver" window, navigate to the driver (/usr/share/java/jtds.jar), and click "Open"
- Right-click on either the new "Microsoft SQL Server 2005" or "jTDS" driver option, select "Connect using..."
- Fill in your database information (port 1433 is often not necessary to enter) and click OK
- Here is the tricky part. It asks you for a Schema. Select "dbo"
20090113
NetBeans IDE 6.5 - MSSQL Server Connection
Sure, I don't use this blog anymore but in the hopes that this will shorten the need for others to figure out how to do it...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment