Hi, Most of you Java Folks may have encountered situations where you wish to code using Java but need to connect to a Microsoft SQL Server Database. To an experienced person, this may seem trivial, but for newbies, this can be a troublesome task. Through this post, I would briefly describe how to connect to Microsoft SQL Server 2005 Express Edition using NetBeans 6.0.1 IDE. STEP 1: Download the relevant JDBC driver from the microsoft site. (A search on the internet will more than suffice) STEP 2: Add the driver to NetBeans IDE. This can be done as follows. On the services tab, under Databases under Drivers, you can add a new driver as follows On the Window, click Add and select the necessary Jar file of the driver. Then click Find. It will search the class name and display it as follows Once the driver is installed, you can right click on it and click 'connect using' Then you will get the following screen Fill in your database name and host address. The port is usually 1433. Yo...
Comments