Hello,
I'm afraid this is a Windows Installer limitation. Please keep in mind that the ODBCDriver table columns doesn't support
formatted type, therefore you cannot use a property reference in the fields from
"Driver Properties" pane.
However, in order to achieve what you want you can configure your ODBC driver using registry value. Every ODBC drivers installation creates at least the following mandatory registry entries:
- Path: SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers
Name: <Driver Name>
Type: REG_SZ
Data: Installed
Path: SOFTWARE\ODBC\ODBCINST.INI\<Driver Name>
Name: Driver
Type: REG_EXPAND_SZ
Data: <Path_to_driver_dll_file>
Path: SOFTWARE\ODBC\ODBCINST.INI\<Driver Name>
Name: Setup
Type: REG_EXPAND_SZ
Data: <Path_to_driver_setup_file>
Path: SOFTWARE\ODBC\ODBCINST.INI\<Driver Name>
Name: UsageCount
Type: REG_DWORD
Data: 1
So, instead of using the "ODBC" page to configure your ODBC driver, you can create the above registry entries (with formatted fields) using our
"Registry" page. Also, in order to see what registry entries will be created for your ODBC driver you can configure it using our "ODBC" page, install it and then observe what registry entries will be created under
SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers and under
SOFTWARE\ODBC\ODBCINST.INI\<Driver Name>. Then, you can create the related registry entries using our "Registry" page.
Also, please keep in mind that if your driver dll file is a 32-bit dll, then the above registry entries should be created under
"Wow6432Node" (e.g.
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers and
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\<Driver Name>).
Let us know if this helped.
All the best,
Daniel