Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Can any one suggest me how to take all the dsn in the system? I need to format the system and i want all the dsn names and connections as a backup.

share|improve this question

migrated from stackoverflow.com Aug 3 '09 at 17:58

This question came from our site for professional and enthusiast programmers.

1 Answer 1

The system-wide settings are stored in HKLM/SOFTWARE/ODBC. If all you are after are these settings you could export this branch of the registry. The per-user DSNs obviously are going to be a problem as they are stored in HKCU and not available to anyone but that user. Be aware that the passwords are stored encrypted so it will only be of limited use.

share|improve this answer
    
I have in fact done this and used the exported registry keys to load matching DSN values on multiple servers. So I'll add something to test for example, and when it's been tested and I want to move it to devl and prod I export the whole ODBC key. I then open it on each of the devl and prod servers and I know they all match. Passwords work too. –  Laura Thomas Aug 3 '09 at 20:15

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.