title: test connection failed because of an error in initializing provider - SSIS
body: <p>Below is my machine information:</p>
  
  <p>Windows Server 2003, service pack 2, 32 bit.
  SSIS package is developed on SQL server 2005.
  Connection string : Data Source=Source;User ID=xxx;Provider=MSDAORA.1;Persist Security Info=True</p>
  
  <p>When I'm trying to connect Oracle DB its showing error (test connection failed because of an error in initializing provider).How can I know, which Oracle client I need to install for this. I checked here (<a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0819acf0-f53e-402a-8113-e8d87f8def5b/test-connection-failed-because-of-an-error-in-initializing-provider-oracle-client-and-networking?forum=sqlintegrationservices" rel="nofollow noreferrer">https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0819acf0-f53e-402a-8113-e8d87f8def5b/test-connection-failed-because-of-an-error-in-initializing-provider-oracle-client-and-networking?forum=sqlintegrationservices</a>). But the answer seems to be for a different versions. How to know, what to install and from where to install ? Please suggest proper link. I hope I have explained it correctly.</p>
  
  <p>Screenshot attached
  <a href="https://i.stack.imgur.com/YvGCV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YvGCV.png" alt="enter image description here"></a></p>
  
  <p>The server registry shows like this:</p>
  
  <p><a href="https://i.stack.imgur.com/qYLNx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qYLNx.png" alt="enter image description here"></a></p>