Database Logon Failed, 64 bit OS

[Former Member]

I have an application that simply saves a report to c: . It works on 32 bit machines but not 64 bit. I have installed the 64 and 32 bit runtimes. It works on xp 32( 2 test machines), server 2003(1 machine) but not on win7 64 bit ot server 2008 r2.

Here is the VsappCode:

  private void button1_Click(object sender, EventArgs e)

         {

        // CrystalReport.rpt is attached to the solution.

             using (CrystalReport rpt = new CrystalReport())
             {
                           
                try
                             {
                                 rpt.SetDatabaseLogon("user", "pass");
                                 rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, @"c:\test.pdf");
                             }
                    
                 catch (Exception E)
                 {
                     MessageBox.Show(E.Message);
                 }
             }

         }

I deploy the app thru a setup project and include the merge modules and detected dependencies: CrystalDecisions.Data.AdoDotNetInterop.dll,CrystalDecisions.ReportAppServer.Prompting.dll.

The merge module included is CRRuntime_13_0_1.msm

I believe the issue references this post: http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/10d5fa88-2013-2c10-c9a5-f11963607...

Specifically this quote "Crystal Reports XI Release 2 (version 11.5) and Crystal Reports 2008 (version 12.1.x) support 64-bit operating systems, but in a 32-bit mode only."

Is there something i need to do to the setup project to enforce this?

Thank you for your time.

[Former Member]

The only way i could get this working was to eliminate the Crystal Connectivity to the data. I loaded the oracle stored procedure return to a dataset within the application and then set the source of the report to this dataset.

I tried all available drivers from within the crystal plugin for VS with no luck.

[former_member11696]

Great you found one work around but be aware that DS's will have memory limts so if the users return a lot of data you are going to generate out of memory errors...

Don