Eclipse3.3 Configuration Data Source-Configure SQL Server 2005

prerequisite, must have Microsoft SQL Server Driver JDBC driver, this driver can go to Microsoft official download

Eclipse3.3 Interface

SQL ServerThe default is offTCP/IPthe data link is,first, find it in the Start menu.SQL Server configruation Manger.in theSQL Server configruation Mangerof whichSQL Serverin the network configuration"MSSQLServerof the Agreement"Open inTCP/IPprotocol, openTCP/IPThe attributes of the protocol, attribute theIPin the addressIP1The activity in and with the startup option selected, save and restartSQLservice.

Open after reboot SQL Server Management Studio Connection database, I connect the database default account is SA the password is empty.

Open Eclipse 3.3 , in Data Source Explorer in the Database selected in New ( newly )

New The form is as follows:

Select Generic JDBC Connection

fill in the description

Name : For the connection name            

Description (description): is a database description

Auto-connect at startup : Automatically Open Data link

To create a data connection setting:

Select a driver form the Drop-down: Select data Connection

Database : Database name

URL : Database path

User Name: user name, which is used here SA

Password : Password

Savepassword: Select Remember Password

then select "Test Connection" to start testing the connection

The following figure is a successful connection and then chooses to complete

after successful connection Eclipse You can use this data to connect the