In my case, we had about 1000 ODBC data sources that needed to be migrated from an old NT 4 IIS server to a new Windows 2000 IIS server.
1. Start -> Run -> regedit
2. Highlight (single click) the following key in the scope pane (left hand side of the window).
\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
3. Choose the Registry menu -> Export registry file -> name it 'odbcreg' and save it to a network share.
4. Go to your target machine, and browse to the same key in the registry. Right click on ODBC.INI and choose 'rename' -> name it ODBC.INI.OLD as a backup.
5. Highlight its parent registry key (ODBC)
6. Choose the Registry menu -> Import registry file -> browse to then share with 'odbcreg' and double click to import.
7. Test your applications that utilize the data sources to verify the import worked properly.
Remember, you can always roll back by renaming ODBC.INI.OLD back to ODBC.INI.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.