Database actions with 64-bit OS and 32-bit database

In order to successfully run SQL queries on a 32-bit database using a 64-bit machine, follow the steps below:

  • Download the .zip file.

  • Extract the contents of .zip file to your desktop.

  • Close all WinAutomation windows, and exit WinAutomation from the system tray (bottom right of the screen) by right-clicking on the WinAutomation icon and selecting "Exit".

  • Right-click on the executable file called "ForceDotnet32bitOnExeFiles.exe" and select "Run as Administrator". This will handle all the configuration changes needed in order for 64-bit WinAutomation to be able to perform SQL queries on 32-bit databases.

  • Restart WinAutomation.

All SQL Actions should now be running correctly.

In order to revert back to 64bit, we can run the TurnOf32Bit.exe (contained in zip file linked above) as administrator and specify the root directory of WinAutomation (by default it's C:\Program Files\WinAutomation).