Bupt Computer Database Experiment Four requirements
This method accesses the database with JDBC-ODBC
(1) Click "Start"-"Control Panel"-"ODBC"
Then open the ODBC Data Source Administrator dialog box
(2) in the ODBC Data Source Administrator dialog box, click the User DNS tab and click the Add button to bring up the Create New Data Source dialog box.
As shown
(3) In the Create New Data Source dialog box, select SQL server in the Driver sequence table, click the Finish button, and the Create new data source to SQL Server dialog box appears, as shown in:
4) In the Create new data source to SQL Server dialog box, enter the data source name in the name (M) text box: SQLSERVER2008_ODBC (You can freely name it, read it well), select the server name in the server (S) text box: xxx** (this varies from person to person, select by drop-down list) * *, click the Next button to enter the Create new data source to SQL Server dialog box, as shown in:
(5) In the Create new data source to SQL Server dialog box, select individual and need to be changed according to the settings you created for your SQL Server. The default is Windows NT authentication. Click the Next button to pop up the Create new data source to SQL Server dialog box, as shown in:
(6) In the Create new data source to SQL Server dialog box, tick the change default database to check box, the default database is master, instead select the database you created, click the Next button, and the Create new data source to SQL Server dialog box appears:
(7) In the Create new data source to SQL Server dialog box, use the default settings. Click the Finish button to bring up the ODBC Microsoft SQL Server Setup dialog box, as shown in:
(8) in the ODBC Microsoft SQL Server Installation dialog box, click the test Data Source button, which indicates that the data source configuration was successful if the SQL server ODBC Data Source Test dialog box is displayed.
(9) in the SQL Server ODBC Data Source Test dialog box, click the OK button to complete the configuration of the ODBC data source, and in the ODBC Data Source Administrator window you can see the ODBC data source you just created: Sqlserver2008_odbc as shown in:
Now that the ODBC data source SQLSERVER2008_ODBC is created, you can then load the JDBC driver for the database connection using an ODBC data source.
Create a new data source for an ODBC data source to SQL Server under WIN7