Skip to Content
0
Sep 23, 2011 at 10:37 AM

CR XI. VS2010. CR Runtime connectivity issues with Oracle 11g

29 Views

Dear Forum

We have an application that was originall developed in VS2005. Using a Oracle 10g dbase connection.

We have recently migrated all our .net to VS2010 using a .net4 framework and have also migrated our dbase to Oracle 11g

Problem is our execution of existing Crystal reports (i suspect the problem is related to compatibility with the runtime 32bit and 64bit environments from my reseach. However i have not been able to find any articles that definitively identify this). So here goes..

We have a number of existing reports that utilise a MS Oracle connection to a stored procedure. These were originally developed in 10g. We are using CRXI Sp2 r6 as our developemt environment.

All these functioned well in the VS2005 / Oracle 10g environment and returned results.

Now we have migrated our app and dbase we are experiencing a error message (see below) when executing these reports through our existing runtime.

We are experincing the following error message.

"An Error has occurred while attempting to load the Crystal Runtime.

Either the Crystal Reports registry permissions are insufficient or the Crystal Reports runtime is not installed correctly.

Please install the appropriate Crystal Reports redistibutable (CRRedist.msi) containing the correct version of the Crystak Reports runtime (x86, x64x or Itanium) required. Please go to* http://www.businessobjects.com/support for more information."

This issue is with stored procedures when you run crystal reports on windows 7 64 bit database,crystal report runtime environment cannot pick up /call the stored procedures which is set as command.

I have modified a couple of the reports believing i could re-establish the connection to the 64 bit oracle dbase. This has been somewhat succesful using crystal reports abut still have the issue when executing through the runtime.

Any suggestions on a way forward would be truly appreciated. Is there a simple solution to this issue or are we looking at something more radical.

Thank you so much for your time and knowledge as ever

With Kind Regards

Paul Marks

Edited by: Paul marks on Sep 23, 2011 12:49 PM