How to transfer ODBC data connections to another computer

Transfer DSN files from Computer A to Computer B:

1. On Computer A, open the Registry Editor by typing “regedit” in the Windows search box under the Start menu and selecting regedit.exe
2. Navigate to the following registry key :
    • For User DSN data sources:
      HKEY_CURRENT_USER > Software > ODBC
    • For System DSN data sources:
      HKEY_LOCAL_MACHINE > Software > ODBC

3. Right-click on the ODBC.INI folder, choose Export, and save the .reg file to the location of your choice
4. Copy the .reg file (or files if you have both User and System DSN data sources) to any location Computer B
5. On Computer B, double click the .reg file(s) to import the DSN data sources to the registry (select “Yes” and “OK” when prompted)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s