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

[paul_marks]

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

[former_member11696 · Accepted solution]

Hi Paul,

Moved to .NET SDK forum.

WOW I'm amazed the MS ODBC Oracle driver worked for you, it only support Oracle 7. If you search MS's site you find this info.

Second issue is CR XI is not supported in VS 2010 nor is 4.0 Framework supported in CR XI, although MS claims it is fully backward compatible Cr requires 2.0 -> 3.5 to be available. Also note you must set the Project for Full Framework and not the Client.

So, a few options, make sure your project is set to x86 only, there is no CR XI 64 bit runtime, 32 bit only so all parts, DB Client, Printer Drivers and dependencies must be installed.

This includes creating your DSN in the ODBC Admin located in windowssyswow64 folder ( 32 bit runtime )

Second option is to go to: http://www.sdn.sap.com/irj/boc/crystalreports-dotnet and bottom of the page has Crystal Reports for VS 2010 which is full featured and you now have inProc RAS available to you, and install the CR for VS 2010 plug-in ( 1st link ) and update your References as well as the Viewer on your form to version 13 assemblies.

Second is to convert all of your reports to Oracles ODBC driver and any ODBC driver that supports Oracle 11g.

Thirdly, search this forum on "ReplaceConnection_click" or Kbase, I believe Ludek created one for the API, and use that code to update the driver in each report.

Thank you

Don

[paul_marks · Accepted solution]

Don

Sorry forgot to mention the driver was a MS OLE ADO connection not ODBC

With Kind Regards

Paul

[former_member183750 · Accepted solution]

Actually, I did a blog on it (which will come up in the searches too, but I should still KB it also). Anyhow, the blog:

[When to use the 'Replace Connection' method using the Crystal Reports or InProc RAS SDK for .NET|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26165] [original link is broken] [original link is broken] [original link is broken] [original link is broken];

- Ludek