Transfer ODBC connections

This PC has a ton of ODBC connections set up. IS there a way to make a copy of them and then load them on my new pc?
Nmark80Asked:
Who is Participating?
 
Bill BachConnect With a Mentor PresidentCommented:
If they are System DSN's, then use RegEdit, go to HKeyLocalMachine/Software/ODBC, then right-click on ODBC.INI and export the entire registry grouping.  For User DSN's, go to HKeyCurrentUser instead.

Edit the file to remove anything that you don't want to reimport, and then double-click the .REG file on your new system.  (All ODBC drivers should be installed manually, if needed, but this will recreate the DSN's.)
0
All Courses

From novice to tech pro — start learning today.