INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
Are you a
Computer / IT professional?
Join Tek-Tips now!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
"...One of the best run forums I have used in years! ...I like the way the site is organized and your no tolerance of flames..."
Where in the world do Tek-Tips members come from?
Migrating ODBC data sources
What's the easiest way to migrate ODBC data sources from one server to another?
Posted: 8 Jun 01
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).
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.
Back to Microsoft: Windows Server 2000 FAQ Index
Back to Microsoft: Windows Server 2000 Forum
Join Tek-Tips® Today!
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
- Talk To Other Members
- Notification Of Responses To Questions
- Favorite Forums One Click Access
- Keyword Search Of All Posts, And More...
Register now while it's still free!
Already a member? Close this window and log in.
Join Us Close