Solved

Export current DSN settings

Posted on 2003-11-27
2
470 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Calculated columns 13 60
SQL for Frequently Bought With 11 45
SQL Server Deadlocks 12 47
SQL Server - SQL field is defined as text 3 26
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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 backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

930 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now