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.

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

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


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.

  • 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

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy