Oracle connectivity

Question

hi Team,

I have one oracle connection manager, I have both username and password.  But, when I try to connect after providing credentials in connection manager and test connectivity, it is failing due to below error.  

Failure message: Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These 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.

can you tell me what needs to be done to overcome this issue?

Thanks in Advance.

Regards,

Rakesh Ponnala.

Answer 1

Hello Rakesh,

Is the Oracle Client installed on your machine incl. TnsOraName file? Can you connect to Oracle using an other tool, e.g. SQL*Plus?

Have you a 32 bit or 64 bit Windows OS? For Visual Studio / SSDT you need the 32 bit Oracle Client.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

we are using 64 bit Windows server OS and Visual Studio 2010.

Answer 3

Then you have to install 32 bit Oracle Client.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]