Modifying ODBC Data Connection Strings and DSNs

  • Article

Applies To: Windows Server 2003, Windows Server 2003 with SP1

If your application establishes database connectivity through an ODBC data connection string or through an ODBC data source name (DSN), you must do any combination of the following:

  • Manually modify ODBC DSNs when the ODBC data connection string references a database that is stored on the source server and the database has not been migrated to the target server.

  • Manually create a system ODBC DSN on the target server for each system ODBC DSN on the source server.

Modifying ODBC DSNs

ODBC data connection strings might need to be modified if they reference the database or are migrated to a different location. For more information about modifying ODBC data connection strings, see Connecting to a Data Source or Driver.

Creating System ODBC DSNs

In addition, if you have system ODBC DSNs that are defined on the source server, you need to create corresponding ODBC DSNs on the target server. Table 6.6 lists methods for administering ODBC DSNs on different Windows server operating systems. You can administer ODBC DSNs on the source server and the target server by using the methods listed in this table.

Table 6.6 Administering ODBC DSNs on Source Servers and Target Servers

Operating System Administered Through Additional Information

Windows Server 2003

Data Sources (ODBC) in Administrative Tools

For more information about using Data Sources (ODBC) in Windows Server 2003, see Help and Support Center for Windows Server 2003.

Windows 2000 Server

Data Sources (ODBC) in Administrative Tools

For more information about using Data Sources (ODBC) in Windows 2000 Server, see Windows 2000 Server Help.

Windows NT 4.0 Server

ODBC Data Sources in Control Panel

For more information about using ODBC Data Sources in Windows NT 4.0 Server, see Help in the ODBC Data Source Administrator in the ODBC Data Sources, in Control Panel.