Preparation of Java using JDBC-ODBC Bridge • Configure Data source steps

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