Saturday, November 28, 2015

How to Install ODBC Drivers Manually

Today I found myself wanting to install some ODBC drivers without installing the whole program responsible for them. Doing it manually isn't too hard:

  1. Decide on or find a name for the interface. This is what goes in ODBC connection strings as the Driver parameter. You should probably use the standard driver name for your database product, maybe look at a computer that already has it installed.
  2. Open the Registry Editor and navigate to HKLM\SOFTWARE\ODBC\ODBCINST.INI.
  3. Under ODBC Drivers, add a new string value named the same as the driver. Set its data to Installed.
  4. Create a new key/folder under ODBCINST.INI with the same name as the driver.
  5. Create entries named Driver and Setup, both containing the full path to the driver DLL without quotes around it. Some database products may require additional configuration here.
  6. If you're on a 64-bit machine and there is a 32-bit version of the driver, repeat steps 3 through 5 for the 32-bit file, in HKLM\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI.
No reboot required.

No comments:

Post a Comment