Install on Windows

Install the Delta Forge ODBC Driver on Windows from the MSI and register it with the ODBC Data Source Administrator.

Syntax

DeltaForgeODBC-<version>-x64.msi

Description

## Overview The Delta Forge ODBC Driver ships as a signed Windows MSI for the x64 architecture. The installer registers the driver with the system-wide `HKLM\Software\ODBC\ODBCINST.INI\DeltaForge ODBC Driver` registry tree so every ODBC-aware application on the machine can see it without further configuration. ## Prerequisites - Windows 10, Windows 11, or Windows Server 2019 or later, x64. - Administrator privileges to run the MSI (per-user installs are not supported in this version). - Released MSIs are Authenticode-signed at build time; if SmartScreen blocks the install, choose **More info** then **Run anyway** and confirm the publisher matches the expected signer. ## Steps 1. Download the `DeltaForgeODBC-<version>-x64.msi` from the Delta Forge release page. 2. Right-click the MSI and choose **Install**, or run `msiexec /i ...` from an elevated shell. 3. Accept the license. The installer copies the driver DLL under `C:\Program Files\DeltaForge\ODBC\` and creates the registry entries. 4. Open the **64-bit** ODBC Data Source Administrator (`odbcad32.exe` in `System32`). The 32-bit administrator under `SysWOW64` does not see the driver. 5. Switch to the **Drivers** tab. **DeltaForge ODBC Driver** should appear in the list. ## Creating a DSN 1. In the Data Source Administrator, choose **System DSN** or **User DSN** and click **Add**. 2. Pick **DeltaForge ODBC Driver** from the list. 3. Fill in the connection-string fields in the setup GUI (Server, Uid, optional Pwd). Click **Test** to verify the credentials before saving. 4. Save with a friendly DSN name. BI tools will pick it up by that name. ## Uninstall Remove the driver via **Apps and Features** in Settings, or `msiexec /x` with the same product code. The uninstaller removes the registry entries and the install directory but leaves user DSNs in place so a re-install picks up the existing configuration.

Examples

# Silent install (admin PowerShell)
msiexec /i DeltaForgeODBC-1.0.0-x64.msi /qn /norestart

# Verify the driver is registered
odbcconf /a {QueryDriver "DeltaForge ODBC Driver"}

# Or open the GUI: start the 64-bit ODBC Data Source Administrator
C:\Windows\System32\odbcad32.exe

Pitfalls

• The 32-bit ODBC Administrator (`%SystemRoot%\SysWOW64\odbcad32.exe`) does not see the 64-bit driver. Always launch the version that matches your client's bitness; modern Power BI Desktop and Excel are 64-bit, but a few ETL agents are still 32-bit.
• If the MSI is double-clicked from a non-elevated shell on locked-down corporate Windows, the install silently completes per-user but the driver registration under HKLM is skipped. Run from an elevated shell or right-click and choose **Run as administrator**.
• If the test connection fails with an `08001` SQLSTATE, the most common causes are an unreachable `Server=` URL, missing or expired credentials, or a corporate proxy not configured in the connection. Open the diagnostic chain in the setup GUI to see the exact message.

See Also

• ODBC_INSTALL_LINUX
• ODBC_INSTALL_MACOS
• ODBC_FIRST_CONNECT
• ODBC_CONN_SERVER
• ODBC_DSN_LOCATIONS