title: Oracle InstantClient ODBC connection fails in DbProviderFactory when the ODBC Test Connect succeeds
body: <ul>
  <li>Installed the InstantCLient 11.2.0.4 Basic Lite and ODBC packages</li>
  <li>Set up the ORACLE_HOME and TNS_ADMIN environment variables and added the path for the installation to the Path environment variable</li>
  <li>Created my tnsnames.ora file in that location</li>
  <li>Set up my DSN using the TNS in the file and did a test connection - succeeded.</li>
  <li>Used C# code I had developed before which uses the DbProviderFactoies generic method of connecting to Data Providers (already works with Teradata, SQL Server)</li>
  <li>Created my Data Source configuration with the following connectionString:<br/>
  <code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
  &lt;configuration&gt;
    &lt;connectionStrings&gt;
      &lt;add name="DataSource" connectionString="DRIVER={Oracle in instantclient_11_2};Data Source=Test Oracle;Persist Security Info=True;Password=password;User=user" providerName="System.Data.OracleClient"/&gt;
    &lt;/connectionStrings&gt;
  &lt;/configuration&gt;</code></li>
  <li>Results in "ORA-12560: TNS:protocol adapter error".</li>
  <li>I tried many variants on the connection string and they all lead to an error of some sort. Any help will be much appreciated.<br/><br/></li>
  </ul>
  
  <p><em>System Information</em><br/></p>
  
  <ul>
  <li>Windows Server 2003 64 Bit</li>
  <li>C# .NET 3.5</li>
  <li>Oracle 11g 11.2.0.3.0 remote database</li>
  </ul>