How to configure DSN

How to configure a file DSN

----Computer room charge system

In imitation of the computer room fee system, we should first understand the "computer room charge system use instructions ——— notepad"

See this use instructions read not understand, online search for a long time also did not find the results. To solve the "profile DSN" problem, I spent 2 days, it is really a struggle.

In the end, Zhao Shuai, Huang Ai Gang, Trichengrong the help of the completed, in this very grateful for their help.

In the process of solving this problem, I found myself the following questions:

(1) The key word is not allowed: Search the information on the Internet, the keyword input is not good, find solutions are not clear.

(2) After finding the data, completely copy the steps above it, not as a guide, do not want to understand its meaning, when the slightest change, and can not find solutions.

Take the reference I found for example: http://wenku.baidu.com/view/336e8a136c175f0e7cd137e0.html

For example: Figure 3 Configuration data source, I found the information is the configuration system DSN, and the description requires the configuration file DSN, I completely follow the steps of the information to do, do not take a more conscious look down.

Figure 6 Log in as reference to "Windows NT authentication using the network login ID" and the instructions require "use SQL Server authentication with user input IDs and passwords."

The result is not available at all after the configuration is finished. This is also fully exposed to do things when the lack of active thinking of the problem, lazy brain.

The correct steps for working through Figure 3 and Figure 6 are:

Configure a data source

Using the SQL Server database, the way to connect to the database is ODBC,

To implement the method, open the start----à settings----à Control Panel---à administrative tools---à data source (ODBC). As shown in Figure 3:

Figure 3 Configuring a data source

Select the "File DNS" option and perform "Add", as shown in Figure 4:

Figure 4 Creating a new data source

In the Select the driver for which you want to install the data source, select SQL Server, and perform the next step, as shown in Figure 5:

Figure 5 Creating a new data source

In "name" fill in the data source, where we fill out the customer management system data source name, must be consistent with the name of the configuration data source in the class (generally fill in the name of the database), fill in the description of the data source in "description" (You may not need to fill in), select the local machine on the server (if you add another server , select the name of the service machine directly), "SQL Server", and perform "next" as shown in Figure 6: Figure 6 The identity of the landing,

In general, you can click Next by default, as shown in Figure 7:

Figure 7 Database Run Setup One

In the "Change the default database to" Select the database to use, where the customer-managed database "Charge_sys" is selected, the other defaults to perform "Next", as shown in Figure 8

Figure 8 Database run settings two

The settings that the database runs, by default, execution completes, as shown in Figure 9

Figure 9 Data source test

here is a description of the data source, click "Test Data Source", as shown in Figure 10, see the success of the test, indicating that the configuration data source was successful.

Figure 10 Test data source

Click OK, the data source DSN configuration is successful.