When I start Reporting4Act!, I receive the message "Error #1733: Failed to initialize StonefieldQuery.ACT2005COM."

StonefieldQuery.ACT2005COM is a component of the Reporting4Act! installation. This error message indicates that this component has not been registered properly with Windows.

The Reporting4Act! installation includes a set of small utility programs to do this registration for you. The particular program to use depends on your version of Act!, and your version of Windows:

• RegisterQueryDLLs1.bat - For use with Act! 2005 and 2006, under a 32-bit version of Windows.
• RegisterQueryDLLs2.bat - For use with Act! 2007 (9.*), under a 32-bit version of Windows.
• RegisterQueryDLLs3.bat - For use with Act! 2008 (10.*) - 2012 (14.*), under a 32-bit version of Windows.
• RegisterQueryDLLs4.bat - For use with Act! 15.* (2013) and later, under a 32-bit version of Windows.
• RegisterQueryDLLs64bit1.bat - For use with Act! 2005 and 2006, under a 64-bit version of Windows.
• RegisterQueryDLLs64bit2.bat - For use with Act! 2007 (9.*), under a 64-bit version of Windows.
• RegisterQueryDLLs64bit3.bat - For use with Act! 2008 (10.*) - 2012 (14.*), under a 64-bit version of Windows.
• RegisterQueryDLLs64bit4.bat - For use with Act! 15.* (2013) and later, under a 64-bit version of Windows.

These files are stored in the Utilities subdirectory of your Reporting4Act! program directory. In most cases, you can simply double-click the appropriate file to run it. The exceptions are if you have a non-standard location for the Windows Program Files folder, or a non-standard location for the .NET Framework. In these cases, you must alter the file to point to the correct location for these items on your system.

These batch files each use 2 files: regasm.exe, and one of SFQueryAct2005COM.dll, SFQueryAct2007COM.dll, or SFQueryAct2008COM.dll. The Reporting4Act! installer places the dll file into the Common Files folder in the Program Files folder. Usually, this is located at "C:\Program Files\Common Files\Microsoft Shared\VFP" (for 32-bit versions of Windows) and "C:\Program Files (x86)\Common Files\Microsoft Shared\VFP" (for 64-bit versions of Windows). If your machine uses a different folder, you will need to modify the command lines in the batch file to reference the correct location on your machine. Similarly, regasm.exe is a part of the Microsoft .NET installation, which is usually located at "C:\Windows\Microsoft.NET\Framework". If your system has this folder in a different location, you will need to modify the command lines as well.

Once you've made these changes (if necessary), double-click the file to run it. On some systems, you may need to right-click on the file and choose "Run as Administrator" to execute it properly. You should see a screen appear with some text ending with "Types Registered Successfully". This should resolve the error message in Reporting4Act!.

Also, the component in question is a fairly minor one, and it's possible to simply switch it off. To do this, edit the file data.ini in the Data folder inside your main Reporting4Act! program folder, and add a ConnectSDK=No line to the [Options] section:

ConnectSDK=No