Wednesday, February 26, 2014

ZST is 67% faster.

For those of you who don't know, the ZST (Zymergi SQL Tool) is a Windows-app that gets your database information and puts it in any format you want.  Typically, customers want to convert their relational data to HTML5 so that they can view (and act on ) it with a desktop or mobile-device browser.

Zymergi SQL Tool

Well, there's good news.  ZST is now 67% faster.  Now, this increased speed may not matter in an enterprise environment where apps are feature-rich, but slow.  But for our customers with external-facing websites, more speed = more revenue.

So why would the enterprise customer want ZST?

Well, the first thing is that this is commercial off-the-shelf (COTS) software.  Secondly, you're essentially adding search and browsing capabilities to your existing relational data.  And ultimately, you're looking to institutionalize tribal knowledge.

Tuesday, February 4, 2014

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.