Insaller issue in Dotnet application

 
I have an installer that runs seamlessly in any 32bit -x86 OS. But if I tried to run the exe(installer) to any 64bit OS, yeah it runs and creates a database, but does not create a tables on it... The installer is compiled in a platform 32bit OS.
 
Do you have any idea about this?
 
Do I need to recompile the application in a 64bit OS?
 
I got the below issue:"SQL Server 2005 Setup cannot continue because the installation package could not be opened. The installation package has a missing file, or you are running a 32-bit only Setup program on a 64-bit computer. To continue, verify the SQL Server 2005 package you are running is supported on WOW64. If you are certain that you are running a supported SQL Server 2005 package, and you continue to see this message, contact the application vendor."
 
Answer:
Obviously, you need to provide two types of installers
 
 
    1. One for 64 bit - x64 platform
 
    2. One for 32 bit - x86 platform.
While creating the installer, you need to change the targerplatform property.
 
Cheers,
Venkatesan Prabu .J