N/APosted on - 05/27/2011
I am operating a Windows 7 Home Premium OS with successfully installed MS SQL Server 2005 and Netbeans version 7.0 beta. Everything is working properly without any problem in software. I want to develop a Java project which is to be connected to a MS SQL Server database.
I am facing a problem that the Netbeans IDE is unable to connect with MS SQL Server database. The databases Node is shown in the Services Window when I click it, SQL Server is not shown but I can see Java DB database. I have registered the JDBC driver for MS SQL Server with Netbeans, but still I don't know how to connect to the database.
Please help me to get rid of this problem. I search on the internet and find different type of manual & help books. I have tried and did by best to follow the instructions.
My problem is still unresolved after following the available instructions.
Problems connecting Netbeans IDE to MS SQL Server database
First of all you must install Netbeans IDE 7.0, Java Development Kit (JDK Version 6) and My SQL Server database Version 5 or higher. Before you access My SQL Server in Netbeans you must configure MYSQL Properties. Log on to your machine with an account with administrative privileges. Navigate to Services window and expand the database node, right click and select Properties.
The IDE enters localhost as server name and 3306 as server port which are default settings. (If you are connected to a different server via different port please fill as appropriate).
Then type the administrator username and password in given fields. Click Admin Properties tab > in Path/URL browse the location of you’re My SQL Admin tool (Location is My SQL installation directory Bin folder).
In the path to start browse the mysqladmin the above bin folder of My SQL installation directory. In the path to stop browse the mysqladmin in the bin folder. In argument field type -u root and click ok.
Ensure that My SQL db is running on your machine. Then go to Services Window > Right click on the db and select connect. In the services, tab right click MySQL Server node and select Create Database.
Type the name of the new db and you are connected.
Please refer to the following links:
NetBeans Connecting to a MySQL Database
Accessing MySQL on NetBeans