title: SSIS: ODBC Connection Issue in BIDS 2008
body: <p>I have an oracle DB i need to talk to so i installed the drivers and added it to the system DSN Data Sources.   IM ON SQL SERVER 2008 R2 64bit</p>
  
  <p>In BIDS, I can see the name of the DataSource, however when i go to enter it in the connection manager I get the following error:</p>
  
  <h2>TITLE: Connection Manager</h2>
  
  <p>Test connection failed because of an error in initializing provider. ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application</p>
  
  <p>Any Ideas on how to resolve this?</p>
  
  <p>I can connect to the Oracle DB through SQL Plus so i know i have connectivity.</p>
  
  <p>Thanks!</p>