The first step in using JDBC-ODBC bridging
Configure the data source
Used in 32-bit systems and 32-bit JDK environments, and now basically eliminated, using JDBC directly is very useful.
1. Enter the Control Panel
2.
3.
4.
User dns: Select this is the only SQL Server user can log in, (recommended)
System DNS: Select this is the user of this computer can log in
Add: is used to add a data source, to enter the next step is to point this
Delete: Delete a data source
5.
It's possible that there are more than two of them in the first step, but it's okay to choose one.
6.
Name: Fill in the name of the database you want
Server: Beginners generally fill in the local, is their own machine, (local), dot small arrows will be more than a lot of network and other machines to choose, do not bother
7.
The first step: the above refers to the selection of Windows user login, so there is no second step
The following refers to selecting the SQL Server user login and need to set the second step
The second step: the first step in the selection of the SQL Server user login needs to set this, select the first one to skip
Fill in a common SQL serve user name and password
Step Three: Point it
8.
9.
10.
End the configuration, and then all OK or fork off the line, I point is OK
Preparation of Java using JDBC-ODBC Bridge • Configure Data source steps