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.
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.