Create a new data source for an ODBC data source to SQL Server under WIN7

Source: Internet
Author: User
Tags microsoft sql server

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.