64 Bit OS and AyaNova programs

Received the following information from an AyaNova user that is using 64 bit OS that was attempting to run the ToMSSQL on the 64 bit OS server to generate the AyaNova SQL database from a stand-alone Firebird database:

The user attempted to run ToMSSQL and receive the following error: “An attempt was made to load a program with an incorrect format. (Exception from HRESULT:0x8007000B)”

The user needs to migrate the Ayanova dB onto a32 bit OS, then copied the new SQL dB to the 64 Bit OS and used SQL server management studio to attach the Ayanova dB.

But than the user ran into another issue trying to set up WBI - in that he has both Microsoft.NET Framework 1.1 and Microsoft.NET Framework 2 installed on this 64 bit OS, and had to run the repair/re-register of the .NET Framework 2
%SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i

This leads me to wonder if the .NET Framework 2 was corrupted / not registered properly on the 64 bit computer as well

Have posted the above in the event other users encounter such an issue as possible suggestions.

Note: Use the Repair command on the Windows Installer cache file to repair the .NET Framework 2.0 by using the Windows Installer cache file, follow these steps:

  1. Click Start, click Run, type installer in the Open box, select Windows Installer and then click OK.
  2. On the View menu in Windows Installer, click Details, right-click the Name column header, and then click Comment.
  3. Right-click the cached Windows Installer file that has the Microsoft .NET Framework 2.0 RTL x86 enu comment, and then click Repair.
  4. After the repair process has completed, quit Windows Installer.

Or :

Repair the Microsoft.NET Framework 2 installation
-Open Control Panel -> Add/Remove Programs Select Microsoft.NET Framework 2 and select Change/Remove Select Repair
-This will take at least 5 or more minutes When finished, you must reboot the computer
-Now run the utility again