?
Solved

Transfer ODBC connections

Posted on 2008-06-12
1
Medium Priority
?
1,031 Views
Last Modified: 2010-05-13
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?
0
Comment
Question by:Nmark80
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 28

Accepted Solution

by:
Bill Bach earned 2000 total points
ID: 21773194
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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question