How Do I Create an ODBC and Configure a System DSN? 100

1.Make sure your computer can access the Internet, click [Run] in the start menu, or you can directly press the shortcut key win+r to open the run window.

2.In the Run window, enter cmd and press Enter to open the command window.

3.Enter the command ipconfig all in the command window, press the enter key, swipe out a bunch of words, and find the IP address behind the [NDS server].

First, right-click on Network Connections, select Open Network Sharing Center, and select Change Adapter Settings in Network Sharing Center.

Select the connection that needs to be changed to DNS, Ethernet if it is broadband, and WiFi if it is wireless. Right-click selection properties are selected.

In the Properties drop-down, find Internet Protocol (IPv4), double-click to open it, and select the checkbox to Manually set DNS

Fill in the DNS number.

Double-click on the desktop computer, click on the property, and then double-click the protocol a few times, and you can see it in the next sentence.

1. Running the program:

1、windows 2000 server：

Select [Start] [Programs] [Administrative Tools] [Data Source (ODBC)] Second, add Set System DSN:

Open the ODBC Data Source Manager, select [System DSN] (as shown in Step 1), and then select [Add] (as shown in Step 2). If DSN has already been set, select [Configure] to reset it.

3. Select a data source

If it is a different data source, select another data source based on the actual situation.

4. Set the data source name:

5. Select the database

2. Select the directory where the database is located.

3. Select the database file.

You can also enter it directly in the database name.

First of all, please see your software's DSN setup help.

This doesn't seem to be easy to say, but to configure DSN, you need to have the UID (username) and PWD (password) of the database.

Here I will talk about the method of configuring DSN in ODBC:

First of all, you must make sure that your database is turned on and that the database ODBC link driver is installed. Then enter odbcad32 in the start menu and press enter. In the displayed ODBC Data Source Manager, select the System DSN tab and click the Add button.

Find your database in the pop-up options and click Done.

The following problem arises, it asks you to enter a data source name (DSN name), this name cannot be taken randomly, it must be the same as the DSN name set in your installed software, and the UID (user name), PWD (password) and database name must also be the same as the parameters written in the software.

If the previous step can be completed successfully, you can do it!

1. Open the BAI board on the control plane and select all DU control panel items.

2. Find zhi to manage.

DAO tool and click Open. Edition.

3. Select a data source.

(ODBC) to open the ODBC Data Source Manager.

4. In the ODBC Data Source Manager, select the second item "System DSN".

5. In DSN, click the Add button on the right to create a data source. In Create a new data source, select Microsoft Access Driver (*.).mdb)”。Click Done.

6. In DSN, click the Configure button on the right to configure a new data source. The data source name and description are arbitrary, just for your own understanding.

7. In the ODBC MicrSoft Access installation panel, click the Select button below the database to select a database on the local disk.

The DSN of the system should be the control plane.

DAO --- DAO --- Microsoft Access Driver (*.) added to the DAO the management DU tool --- the data source ZHI (ODBC) -- System DNS ---mdb) -- press select to return to the database answer. Haven't heard of adding DNS to access

1. Establish a BAI database.

1. First of all, DU creates a new database in access. (I don't need to say dao for this, right?) ) within.

2. Establish a system DSN data source.

1. Open "Control Panel Management Tools Data Source (ODBC) MS Access Database".

2. Click "Add" and select "MS Access Database", then give the data source a name, such as iChat.

3. Enter the alias of the database in the "Data Source" column.

4. Click "Select" in the middle of the database bar and select the database location you created.

5. Click "OK" to complete.

Two factors: 1, many of the drivers of the XP era have been eliminated. 2. There are too few drivers installed for other databases on your computer.

This is to create another ODBC data source so that Phone Spy Enterprise can connect to the database.

1) Open "Control Panel" - Management Tools - Data Source (ODBC) in turn;

2) Click "System DSN" - Add";

3) Select Microsoft Access Driver (*MDB) and click Finish.

4) First fill in a name for the data source and click "Select";

5) In the database name, select the database file to be connected to and click OK. Note: The database is different from the above figure due to the different storage location or name, and you should select the positive one by "Drive" and "Directory".

exact path and database file.

6) At this point, the basic settings are complete, if you set the password when creating the database, then you also need to click "Advanced", finish.

into some necessary settings;

7) Fill in the "login name" and "password" of the database, and click "OK";

8) At this point, the ODBC data source has been set up, and finally click OK.

ODBC is connected to a database.

The system DSN is the type of database to which you connect, such as SQL Server, and the access user DSN is the name of your database, which you can ...... as you like

File DSN is the name of the database in SQL Server.

I don't know anymore I used odbc to do legends.

The file dsn is the file that establishes the dsn, and the information is stored in the file.

The system DSN establishes a system-level DSN, which is available to all logged-in users of the system.

The user DSN is only available to the user who built it.