Installing ICIS on Windows 7 64 bit

From ICISWiki

The problem is is that the MSACESS ODBC driver is not available by default on the 64 bit systems so the installer cannot install the DSNs. The driver is hidden in a directory called %windir%\SysWOW64 where you will find a file the 32 bit ODBC administrator tool - odbcad32.exe. I managed to install the DSNs manually by running this program so you have to copy all the ICIS files to the appropriate directories and then run this program and specify the DSNs

NSIS Installer for ICIS on Windows 7 (64-bit)

Some things that were observed when trying to create and IWIS3 installer for a Windows 7 system that was 64-bit.

1. NSIS understands well Windows 7 and lets internal variable $PROGRAMFILES point to C:\Program Files\ in case of XP, and C:\Program Files (x86)\ in case of Windows 7 with 64-bit.
2. There is an internal variable X64 in a plugin of NSIS that will be true if it is run in a 64-bit operating system, and false if not.
3. In case of both the path and the “working directory” of ODBC Sources (which I make a desktop shortcut to) it must point to C:\Windows\SYSWOW64\odbcad32.exe as seen above
4. When creating a ODBC connection via NSIS, one of the entries of the registry will contain a link to myodbc5.dll like this
WriteRegStr HKLM "Software\ODBC\ODBC.INI\iwis_central_dms" "Driver" "$PgmFiles\MySQL\Connector ODBC 5.1\myodbc5.dll"
I tried to confirm the above connection from ODBC sources by clicking the “Test” button, and it would fail if this link was not correct, so the whole ODBC definition (here iwis_central_dms) would fail, but this was only because I was doing something wrong instead of just using $PROGRAMFILES which NSIS would handle correctly.
(Jesper Nørgaard)