Move ODBC from one workstation to another

Subject: Move ODBC from one workstation to another

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

Your email address will not be published. Required fields are marked *