Wednesday, June 25, 2008

Using Stonefield Query on 64-bit Windows

Although it's a 32-bit application, Stonefield Query works just fine on 64-bit versions of Windows, including Windows Vista, Windows 7, Windows Server 2003, and Windows Server 2008.

One known issue with Windows, however, is that 32-bit applications can access 32-bit system DSNs, 32-bit user DSNs, and 64-bit user DSNs, but not 64-bit system DSNs. Since the default ODBC Administrator is the 64-bit version (you can run the 32-bit version from the SysWoW64 subdirectory of the Windows folder if necessary), any system DSNs you create aren't visible to Stonefield Query. So, either create user DSNs rather than system DSNs or use the 32-bit ODBC Administrator to create your DSNs.

This impacts any version of Stonefield Query that uses ODBC DSNs rather than connection strings, including:

  • Stonefield Query SDK (if you turn on the User Can Manage Data Sources configuration setting)
  • Stonefield Query for GoldMine
  • Stonefield Query for HEAT
  • Stonefield Query for MAS 90 and 200
  • Stonefield Query for Sage Accpac ERP
  • Stonefield Query for Sage BusinessVision
  • Stonefield Query for Sage Pro ERP (SQL version)