Windows ODBC DSN and driver locations in the registry
Where ODBC DSNs and drivers are stored in the Windows registry, and how to export their configuration.
On Windows, ODBC data source names (DSNs) and ODBC drivers are stored in the registry. This page shows where to find them and how to export their configuration, for example to send to support.
Registry locations
| Item | Key |
|---|---|
| System DSN (64-bit drivers) | HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI |
| System DSN (32-bit drivers) | HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI |
| User DSN | HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI |
| Drivers | HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI |
Export a DSN
- Open the Registry Editor (
regedit). - Go to the matching ODBC.INI key (64-bit system DSN, 32-bit system DSN under
Wow6432Node, or user DSN under HKEY_CURRENT_USER). - Click the data source name.
- Choose File > Export. The file is saved with a
.regextension. - Rename the file to
.txtbefore sending it to support.
Export a driver
- Open the Registry Editor and go to
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI. - Click the driver name, then choose File > Export.
- Go to the
ODBC Driverssubkey of the same key, click the driver name, then choose File > Export. - Rename each
.regfile to.txtbefore sending it.
Troubleshooting
If a DSN does not appear in the ODBC Administrator (odbcad32.exe), the DSN name may be missing from the list of DSNs in the ...\ODBC.INI\ODBC Data Sources subkey.