Windows system creates an ODBC data source

Take Win7 as an example of how to create an ODBC data source as follows

1. Open the Control Panel

2. Click "System and Security"

3. Click on "Administrative Tools"

4. Open the data source (ODBC)

5. Click "Add"

6. Select the driver, choose one on the line, here I choose ODBC Driver 11

7. Define the data source name and select the server. The data source name here is the data source name required by the Drivermanager.getconnection method when JDBC programming

8. Select the identity and click Next. Here I select "Integrated Windows Authentication"

9. Change the default database and select the database you want to manipulate

10. Change settings on demand, click Done

Windows system creates an ODBC data source