32-Bit versus 64-Bit Integrator
Integrator is provided only in a 64-bit version within Workbench for
ODBC Connections
When possible, update any ODBC connections to use a 64-bit driver. If you must continue using a 32-bit ODBC driver, you need to use the following workaround:
- Run a 32-bit Integrator (from a previous Diver Solution 6.4 installation) to do just an extraction of the data to a system directory.
- Use a System Alias in Workbench to bring the data into the Workbench project.
For Windows machines, note that the ODBC drivers are typically located as follows:
- The 32-bit version of odbcad32.exe is located in the %systemdrive%\Windows\SysWoW64 folder and manages the 32-bit DSNs
- The 64-bit version of odbcad32.exe is located in the %systemdrive%\Windows\System32 folder and manages the 64-bit DSNs