Solved

Export current DSN settings

Posted on 2003-11-27
2
481 Views
Last Modified: 2012-08-13
Is there a way to save the current collection of DSN settings to be re-installed after a server rebuild?
0
Comment
Question by:juststeve
2 Comments
 

Author Comment

by:juststeve
ID: 9831830
system DSNs, that is
0
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 250 total points
ID: 9832449
They are in the registry.

1. Go into Regedit (Start/Run, then type Regedit)
2. Find this Hive: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
3. Select your ODBC connection then press Registry/Export Regitry File and export it
4. Select this Hive: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources
5. Press Registry/Export Regitry File and export it
6. Open the REG file created in step 5 and Copy the single line that has your ODBC connection in it
7. Open the REG file created in step 3 and Paste the single line that has your ODBC connection in it (anywhere after the first line) then save this file
8. When you double click on the file you created in step 7, it will add your ODBC connection to the registry.

You can grab all of your DSN's this way and put them in one file.

0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

786 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