title: Oracle instant client with C# windows forms application
body: <p>I have been looking for this for long time ,
  I have developed Windows Forms App using C # that have to connect Oracle database, 
  this app will be used on many PCs using windows XP and windows 7
  After long research i have found that i need to use OBP.net for oracle access but problem is i cannot install oracle client on every PC, However i found work around  in <a href="http://www.codeproject.com/Articles/18692/Instant-Oracle-Using-C" rel="nofollow">CodePorject Example</a>to download 5 DLL files to do the same job </p>
  
  <pre><code>OCI Instant Client Data Shared Library
      oraociicus10.dll (Basic-Lite version)
      oraociei10.dll (Basic version)
  Client Code Library
      oci.dll
  Security Library
      orannzsbb10.dll
  OCCI Library
      oraocci10.dll
  </code></pre>
  
  <p>But when i release the app it dosent connect  to Oracle Database 
  Please help how i can have my Windows Forms app connecting Oracle Database with no oracle client installed PC and if this is achievable through the above DLLS how i can do that ?</p>
  
  <p><strong>EDIT:</strong></p>
  
  <pre><code>DataTable dt = new DataTable();
  OracleConnection Oracle_connection = new OracleConnection();
  Oracle_connection.ConnectionString = con;
  Oracle_connection.Open();
  </code></pre>
  
  <p>got connection timeout, in <code>Oracle_connection.Open();</code> in debugging mode and I dont use TNSNAMES.ORA as my connection string is as</p>
  
  <pre><code>Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.2.54)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = PRD))) ;User Id=catering;Password=catering;"`
  </code></pre>
  
  <p>Tried to publish the code it worked on Windows 7 PC but didnt work on Windows XP 
  <code>System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception. ---&gt; Oracle.DataAccess.Client.OracleException The provider is not compatible with the version of Oracle client    at Oracle.DataAccess.Client.OracleInit.Initialize()</code></p>
  
  <p>Dunno if it's windows related or some DLLs are missing</p>