System.Data.OracleClient vs Oracle.DataAccess

[Rui]

Hello, if I want set to use providername = System.Data.OracleClient
why is openaccess complaining about Oracle.DataAccess?

It's a 3.5 application.


System.Configuration.ConfigurationErrorsException: Database provider Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c47342 not installed properly (CLR=v2.0.50727 32bit). ---> System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
File name: 'Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c47342'
   at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName)
   at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
   at System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
   at System.Type.GetType(String typeName, Boolean throwOnError)
   at OpenAccessRuntime.ProviderFactoryLoader.LoadImpl(String name, LogEventStore log, Int32 id)

[Ralph Waldenmaier]

Hello Rui,

The provider System.Data.OracleClient is a Oracle client provided by Microsoft within the .NET framework. Since this provider is deprecated, it is recommended to use the Oracle.DataAccess.Client which is provided by Oracle. You can download the provider here. 
You can find additional information in our documentation.

Feel free to ask if you have any other question.

Regards,
Ralph
the Telerik team

[Rui]

OK. I understand.
So we should not use System.Data.OracleClient.

Note: Check the documentation it's missing something.

"... has been tested with the 9, 10R2 an"  maybe you wanted to say: and 11....

[Ralph Waldenmaier]

Hello Rui,
Yes, you should not use the System.Data.OracleClient client, but the ODP.NET client provided by Oracle.

Thank you for the documentation hint. We will correct this. 

Greetings,
Ralph
the Telerik team

[Sushil]

Hello Everyone,
            I am also getting same error, can anyone please help me. Its urgent .

[Ralph Waldenmaier]

Hi Sushil,

Can you please ensure that you have installed the appropriate Oracle .Net Client provided by Oracle. It can be found here. Also please ensure that you have installed the architecture version that matches your applications architecture. In case you specified 'Any CPU' then you need to install the version based on the architecture of your operating system.

Hope this helps.
Do come back in case you need further assistance.

Regards,
Ralph
Telerik