LLI Wiki — My Digital Knowledge Base

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

  1. Open the Registry Editor (regedit).
  2. Go to the matching ODBC.INI key (64-bit system DSN, 32-bit system DSN under Wow6432Node, or user DSN under HKEY_CURRENT_USER).
  3. Click the data source name.
  4. Choose File > Export. The file is saved with a .reg extension.
  5. Rename the file to .txt before sending it to support.

Export a driver

  1. Open the Registry Editor and go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI.
  2. Click the driver name, then choose File > Export.
  3. Go to the ODBC Drivers subkey of the same key, click the driver name, then choose File > Export.
  4. Rename each .reg file to .txt before 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.

Mastodon LLIMastodon SocialFosstodon