Error connecting from .net to Oracle

-2

I am setting up a new WS2012R2 server to host applications; the applications are made in .NET 2.0 and are connected to Oracle 10g.

The connections are made through OLEDB.

On the new server I have already installed the Oracle client and tnsping and it works normally, but when I connect from my app I get the following error:

  

Oracle client and networking components were not found. estos   components are supplied by Oracle Corporation and are part of the   Oracle Version 7.3.3 or later client software installation.

     

Provider is unable to function until these components are installed.

What can be the solution to this situation?

Now that I realize everything is born like this: This was an app in .net 1.1 (I imagine that therefore in x32), it was migrated to vs2008 with .net 2.0, when I compiled it for x86 it appears the message of the question (above), when I compile it for x64 the message appears: "The provider 'MSDAORA.1' is not registered on the local machine." all the tests now I'm running on a w7x64 and ws2012x64, I think with that additional information and could help me identify the problem.

    
asked by RSillerico 08.09.2016 в 20:22
source

1 answer

0

Remember that you have to install ODAC on the pc from where you connect to Oracle

64-bit Oracle Data Access Components (ODAC)

I do not know what version of windows you're going to run, maybe if it's 64bit you should look for the link with that distribution

With the ODAC you will have the libraries to connect, counting with tnsname.ora

Then use the libraries that ODAC installs to develop, do not use the ones included in the .net framework because they are deprecated

Build a .NET Application on the Oracle Database with Visual Studio 2005 or 2008

in the article you will see how to define the conection string

    
answered by 08.09.2016 в 20:59