Developing database Interconnect ODBC configuration

Open Database Interconnect (ODBC) is a kind of early database interface technology introduced by Microsoft, which can access database data through ODBC driver, and can complete the link operation to database by using ODBC Administrator.

System DNS: This data source is configured, and all users of the current server can use this data source to link the database. As shown in the following:

1. Add driver: SQL Server connection

2. ODBC name and connection server name

3. Connection authentication method: Windows connection

Connect to the database using your current Windows account and password. Therefore, there are two situations in the following ways:

A, the target server and the originating server are in the same domain, if the Windows current user is logged on with a domain administrator account, you can verify the pass.

B, if the target server and the originating server is not a domain server, requires the same account between the two servers, and the same password, and set the Security Trust link in the database. Before you can verify the pass.

4. Select Database

5. Click Finish

6. Set up links in bulk by script.

@echo off

echo is deploying ODBC ...

odbcconf configsysdsn "SQL Server" dsn= fill in the DSN name | server= fill in the database IP or alias that needs to be connected | database= fill in the database you need to access | Trusted_connection=yes "

Developing database Interconnect ODBC configuration