Zymergi SQL Tool (ZST): Could not load file or assembly 'System.Data.SQLite'

For ZST customers moving to 64-bit environments, you may run into the:

Could not load file or assembly System.Data.SQLite error.

This error is caused by the default setting of IIS7 to not use mixed-mode assembly. What is mixed-mode assembly? Well, when you have 3rd-party software libraries written in on x86 systems, you're in a mixed-mode. Since this is disabled by default, when you migrate ZST to IIS7, you're going to get this error.

Here's the solution:

Step 1: Open IIS 7 Start > Run > Type in 'inetmgr'.

Step 2: Select Application Pools.

Step 3: Right-click Advanced Settings...

Step 4: Under General, set Enable 32-Bit Applications to True

Once get this going, you ought to be back in business.

Thanks to StackOverflow for this solution.