Is Oracle.ManagedDataAccess supported?

[Former Member]

Hello

I have spent many days unsuccessfully to try to get a Crystal Report to use the .net driver Oracle.ManagedDataAccess.dll.

This Oracle's managed ADO.NET driver. It does not need to be "installed" on the machine and it is not in the windows registry. It can reside in the application's exe directory an is added at application run time to the .net providers by references in the application's config file. Not to be confused with Oracle.DataAccess.dll which is their un-managed that DOES need to be installed.

The other great feature is that Oracle.ManagedDataAccess.dll has a built in client so the Oracle client also does NOT need to be installed on the client machine. The same dll runs on both 32bit and 64bit.

For the last 10 years, our Crystal Reports have been designed using Microsoft's ADO driver System.Data.OracleClient. To run a report at our customer location, we change the schema name, user name and password at runtime using the SetConnection() function on the DataSourceConnections object.

This has worked fine for years but it does not change the provider, and thus the Microsoft provider System.Data.OracleClient still is used when run at the customer site. This driver has been deprecated for several years and also requires that the oracle client be installed on the customers machine.

I have tried 2 different (but I think equivalent) approaches to change the provider at run time. I have tried changing the "QE_LogonProperties" item in the logonInfo.ConnectionInfo.Attributes collection. I also downloaded the utility that loads a report and gives you the RAS code to change connection (including provider) info. Nothing has worked.

I am really not sure what the issue is, so I have these questions:

Is it possible that this driver is not supported because it is not in the windows registry?

Can you tell me exactly how to specify QE_LogonProperties to use this driver?

And one less important question: I notice that when I am changing the schema/user/password at run time, it takes a bit of time for each table and each sub report, almost as if it is loading data. And then there is a another delay to get the data when the report is actually run. Is there a way to avoid this delay when setting the connection data for all the tables and sub reports?

I believe that previous thread 3274186 asked this same question, but that was a few years ago. I dont feel that it was really answered and also possibly support for this has now been added?

Thanks so much.

Tom

[janos_mucsi-besze]

Hi Tom,

I also looked for any available documentation that clearly answers your question. Unfortunately there isn't any. This means to provide you an answer we at SAP must discuss this first internally. But we need an SAP incident in our hands to do this. I ask you therefore to open an incident either in BC-DB-ORA or a component related to Crystal Report.

Thank you for your understanding.

János