VS2005 and CR 2008 (V12) and Windows Server 2008 R2 x64 Issue
We have VS2005 web application on .Net 2.0 running fine with CR 2008 v12 runtime (CRRuntime_12_3_mlb) on BOTH a) .Net 2.0, IIS6, Win XP and b) .Net 2.0, IIS7, Windows Server 2008 32-bit edition. The reason we have chosen CR 2008 v12 (against integrated VS2005 CR 10.2) is its ability to allow dynamically load images in reports (we have reached this level after a lot of pain) and it works great too.
However switching from Windows 2003 server to Windows 2008 R2 x64 Server give crystal report problem - Deploying website on .Net 2.0 framework Windows Server 2008 R2 (64 bit) using IIS7 and installing CRRuntime_12_3_mlb (installed fine) and then running report, it gives this error 'The type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocument' threw an exception'. Application Pools are set for .Net 2.0 and Enable 32-bit Application as True. Not sure what we are missing.
I read many posting and have summary of questions:
1) Does CR 2008 v12 Runtime SP3 or even SP5 not support x64 OS like Windows Server 2008 R2?
2) Do we need to deploy our web application in x86 mode instead of 'Any CPU'? [We could not find x86 explicit mode choice for Project_deploy in VS2005 but added x86 for Release in project file and are able to create deployment files but need to test online - I am crossing my fingers to see what results we will get.]
3) I read in some threads a suggestion of moving to VS2010 with .Net 4.0 and using Integrated 10.5 version and using CRRuntime_64bit_13_0_2.msi to deply on Windows Server 2008 R2 64bit. I do not know if this is a downgrade for crystal report from 2008 v12 to 10.5 or upgrade from 2008 v12 to runtime v13 just because we want reports to run on Windows Server 2008 R2! We can take risk of moving from CR 2008 v12 to Integrated 10.5 from VS2005 to VS2010 but not sure if
a) it retains our ability to dynamically load images in reports AS WELL AS
b) supports runtime reports on 64bit Windows Server 2008 R2?
If anyone can help us solve and run crystal report on Windows Server 2008 R2 64bit, it would be great?
Thanks in advance.