This discussion is archived
6 Replies Latest reply: Sep 4, 2012 8:58 PM by 959748 RSS

Issue in connecting Oracle 11g  to the .Net Framework 4

959748 Newbie
Currently Being Moderated
Hi All,

I am trying to install a 3rd party application,which connects to oracle database in my windows 2008 R2 machine.
When i test the database connection i am getting the below error

"*For DBEngineType: 'Oracle' the selected provider invariant name is: 'Oracle.DataAccess.Client'*

*Test connection failed: Unable to find the requested .Net Framework Data Provider. It may not be installed*."

OracleDataAces is present in the C:\Windows\assembly path.I added the following lines in the machine.config also under Framework as well as Framework64 folder

" <DbProviderFactories>
<add name="Oracle Data Provider for .NET"
invariant="Oracle.DataAccess.Client"
description="Oracle Data Provider for .NET"
type="Oracle.DataAccess.Client.OracleClientFactory,
Oracle.DataAccess,
Version=2.112.1.2,
Culture=neutral,
PublicKeyToken=89b483f429c47342" />
</DbProviderFactories>
"
still Iam getting the same error

.net Framework version is: 4.0
Oracle DataAccess Version is : 2.112.1.2

Do I have to set the path of the Oracle DataAccess or do i have to get the upgraded version of this?
Plz let me know what to do?

Thanks,
Mouli

Edited by: 956745 on Sep 4, 2012 2:56 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points