title: Oracle ODBC ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV
body: <ol>
  <li>I have installed the Oracle client 10g (release 10.2.0.1) on to a windows 2008 64bit machine. </li>
  <li>I have set up the tnsname.ora file, checked the path (starts with path to oracle client folder) and oracle_home variables. </li>
  <li>I have also checked the security permissions on the client folder and this has read/write for the authenticated user.</li>
  <li>I set up an ODBC32 connection using the Oracle Oracle Driver (as opposed to the Microsoft one) and tested connection successfully.</li>
  <li>I set the Runtime64Bit property in the project in SSIS (SQL Server 2008 R2) to false.</li>
  </ol>
  
  <p>When I try to test connection of this ODBC DataSource in SSIS I get this error</p>
  
  <blockquote>
    <p>Test connection failed because of an error in initializing provider.
    ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle
    on SQL_HANDLE_ENV failed</p>
  </blockquote>