Crystall RUntime on 64bit vs 32bit computer

[former_member604526]

We have a Windows forms .net app which uses a Crystal reports viewer.

I am trying to install our production application on a 64bit computer, our users computers up until now have been 32bit. I have installed the CRRuntime_32bit_13_0_3.msi run time (which is the current version installed on our users computers) and I have tried the CRRuntime_64bit_13_0_3.msi version of the crystal runtime on the computer.

I was getting this error when I was using the CRRuntime_32bit_13_0_22.msi:

"Could not load file or assembly 'CrystalDecisions.Web, version=13.0.20000......."

I have since installed the version of the runtime (CRRuntime_32bit_13_0_3.msi) that is installed on our users computer and get this error:

"An error has occurred while attempting to load the Cyrstal Reports runtime. Either the Crystal Reports registry key permissions are insufficient, or the crystal Reports runtime is not installed correctly...."

If I install the CRRuntime_64bit_13_0_3.msi version of the runtime it prompts me to enter the Login Id and password. It does have the server name field is filled in but the Database name is blank., and these two fields are disabled.

[DellSC · Accepted solution]

"This is a really old application and has run for years..."

What OS are you installing it on? In the initial question you mentioned that you had been using the 13.0.3 msi. This is for service pack 3. This version doesn't support Windows 10 if that's where you're installing it, although you might be able to use the Compatibility Troubleshooter to set the application to run as if it were on an earlier version of Windows.

One of the tricks for getting applications written with the SDK to run properly after they've been deployed is that you must have the same version (service pack) of the SDK installed in VS and on the target machine when you deploy your application. If you need to upgrade to a newer version to work with a newer OS, you will need to recompile your application with the SDK version that you're going to use to deploy. Also, there have been a few changes in the way some things are done with the SDK (nothing major). If you look at the wiki here, it will tell you what changes need to be made. That page also contains links to the site where you can download the SDK. When you get to the download page, the orange button gives you the integration with VS and the blue buttons are links for the various runtime installs that are available.

-Dell

[former_member604526 · Accepted solution]

really old in computer years... this was a VB6 application that was rewritten in .net by a student 5/6 years ago. It is currently running on 32bit windows 7 computers. I am trying to install it on a 64bit Windows 10 computer. I would have thought just using the 64bit version of the same runtime would have worked.

I will have a look at the information you provided.

[former_member604526 · Accepted solution]

Dell,
I have uninstalled CRforVS_13_0_22 from my development computer, then rebooted my computer

I have installed CRforVS_13_0_24 by right clicking on the exe and running as administrator. Then rebooted my computer

Removed the 4 crystal references in the project and readded them.
I replaced the report viewer in the application.

I have set the application to 64bit, as before it was set to any cpu.

I uninstalled our application and the crystal runtime from my 64bit windows 10 test computer.

I installed the 64bit version of the SP 24 runtime.

I installed our application and it is still prompting for a username and password when our application tries to open a report.

I have gone 64bit because our new WIndows 10 comptuers have the 64bit oracle client. Our old Windows 7 computers were 32 bit with the 32bit oracle client.

[DellSC · Accepted solution]

You may need to make a few changes in the application because there have been changes since earlier versions of the SDK. Have you implemented everything that is described here: https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads?

Also, in the "Related Content" section of that wiki page, there are two links that are bold. Either one of them can be used as testing/sample code to make sure that you're setting the connection to the database correctly. Since you're connecting to Oracle, are you using an ODBC connection or Crystal's native Oracle connection?

-Dell

[former_member604526 · Accepted solution]

I finally got it to work, I had to change the database connection type in the crystal reports the application is running. As I had said the cr reports are sitting on a file share.
The reports had been created with an OLE db connection, I changed a couple of them to Oracle server connections and was able to run them in our application. Now I am going to start over and see what changes I made are needed and which ones are not needed.

thanks for all your help.

[former_member604526]

another bit of information. This app is running reports that are on a share and are not part of the application.

[former_member604526]

All,

Is Microsoft update KB2999226 a prerequisite for Windows 10 computers as well?

As mentioned on

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

[msundararaja_perumal]

Hello,

I think for permanent solution, recompile into 64 bit will be more apt.

Thanks.

[former_member594930]

We just recently upgraded a similar application that was using old crystal dlls. We not only had to upgrade the runtime to 64 bit version , we also had to add references to the dlls(removing original references) from the code.

To get these, we downloaded CR for VStudio from SAP Website , while installing it detects which O/S it is 32 or 64 bit and installs the appropriate run time. Once we had it we were able to get to the DLLs. The apps are working fine.

[DellSC]

No, it's not corruption of the install.

When determining which "bit-ness"to install for the runtime, you need to look at the application, NOT at the computer where you're installing it. It is recommended that you do not compile your application with a target of "any CPU"; instead, you should specifically target either Win32_X86 (32-bit) or Win64_x64 (64-bit). You would then install the version of the runtime that matches the bit-ness of the application.

I suspect you have a 32-bit application and you've installed the 64-bit runtime. Uninstall the runtime and install the 32-bit version instead.

-Dell

[former_member604526]

Thanks Dell,

I have since installed the version of the runtime (CRRuntime_32bit_13_0_3.msi) that is installed on our users computer and get this error:

"An error has occurred while attempting to load the Cyrstal Reports runtime. Either the Crystal Reports registry key permissions are insufficient, or the crystal Reports runtime is not installed correctly...."

If I install the CRRuntime_64bit_13_0_3.msi version of the runtime it prompts me to enter the Login Id and password. It does have the server name field is filled in but the Database name is blank., and these two fields are disabled.

I tried to make the change with the Any CPU. But I have been trying so many things maybe I didn't install the proper versions of the run times. I will try it again.

[DellSC]

Were you logged in to the server with Administrator rights when you did the install? If not, that's the problem. The install sets a number of registry entries, which it can't do unless you have Administrator rights.

-Dell

[former_member292966]

Check to see if your application is running as 32 or 64 bit. Easiest way is to run your application and check the Windows Task Manager. It will tell you if the application is running in 32 bit or not.

You will need to make sure the database client also matches the bit version.

Good luck,

Brian

[former_member604526]

Dell,

This isn't being installed on a server. This installed on the users computer (clickOnce install). But I have been doing the install manually to try the different runtimes.

I checked the oracle client installed on the computer. It is 64bit. I made the application a 64 bit application. I installed the 64 bit runtime. When the viewer tries to open the report it is prompting me for a user name and password.

[DellSC]

That is a different situation. Crystal doesn't keep the password for a connection, so you would have to set it in your code. In Don Williams' blog here, there is a link to download sample code that will show you how to do that.

-Dell

[former_member604526]

This is a really old application and has run for years..... The login ID and password are being set in the code.

objReport.DataSourceConnections.Item(0).SetLogon("username", "password")

The server name field is filled in but disabled, and the database field is disabled but not filled in. Do I need to set the database name in the code? Seems weird that that would be the answer and it has worked for years.

[msundararaja_perumal]

Hello,

The error is due to corruption in the installation of CR.

You can follow the steps mentioned in note-1758302 to rectify this issue.

Thanks.

[former_member604526]

What do you mean by corruption to CR? On the users computers they don't have crystal reports installed, just the runtime.

I am not having an easy time navigating the SAP site to find note 1758302, once I do I will let you know what happens.