We are packaging some of our databases using version 22.214.171.124 of SQL Packager. When we run the comipled output on a 32 bit machine, the database installs into SQL Server successfully. When we run the same compiled output on a 64 bit machine, it crashes with the error:
"An attempt was made to load a program with an incorrect format (Exception from HRESULT: 0x8007000B)"
On the 64 bit machine, it successfully creates the database specified on the settings page, but it is empty so it seems the problem is in trying to run the packaged SQL.
Is there a known issue with 64 bit machines? Can I just replace the template solution with a VS2005 one set to "Any CPU"? Any other workarounds?