How to move ODBC DSN information from one computer to another

YAAAAAAAAY!!!! I got a new computer!!!Data-transfer

Oh crap how do I move the DSN connections that I made on this computer?? This is how (assuming you’re on windows)! But before, we do, we have to make sure we have the right drivers… so lemme first go over the basikses my precious:

TO ADD NEW CONNECTIONS:

  • Build a shortcut on your desktop to: C:\Windows\SysWOW64\odbcad32.exe
  • Add connections from there.

IF IN THE NEW COMPUTER YOU CAN’T ADD THE NEW CONNECTIONS YOU NEED:

  • You need to download the drivers. In my case, since I want to talk to Azure databases, I need this driver: http://www.microsoft.com/en-us/download/confirmation.aspx?id=36434. That worked for me, you get what you need and download it.
  • Install it. It will automatically add the connection type ODBC Driver 11 for SQL Server (or whatever) to your odbcad32.

OK, now that you’re all set and you know your new pc can do the connections, without further ado:

TRANSFER DNS 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 : HKEY_CURRENT_USER > 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)

 

done!

Leave a Reply