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
<add name="Oracle Data Provider for .NET"
description="Oracle Data Provider for .NET"
still Iam getting the same error
.net Framework version is: 4.0
Oracle DataAccess Version is : 126.96.36.199
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?
Edited by: 956745 on Sep 4, 2012 2:56 AM
Okay, if the application is 64 bit and you installed the 64 bit Oracle client, the installer should have taken care of the registrations and path settings for you.
What exactly did you install? Can you point me to where you downloaded it?
Oh, yeah that's not going to work. Oracle.DataAccess relies on the Oracle client for it's actual connectivity to Oracle. If you don't install the client, you will never get that assembly to do anything.
Remove any changes you made to machine.config and install the Oracle client. For 64-bit .net applications, this page should have what you need: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html