title: Connecting to Oracle Database through Excel
body: <p>I'm trying to connect to an Oracle Database on our server from an Excel sheet, but am having trouble understanding why. </p>
  
  <p>I currently have <strong>both</strong> 32-bit and 64-bit Oracle 12c installed in different <code>ORACLE_HOME</code>s and have a 32-bit installation of Excel on my 64-bit computer.</p>
  
  <p>I'm trying to connect to an Oracle Database in Excel using the <em>New Query</em> wizard. </p>
  
  <p><a href="https://i.stack.imgur.com/djcbs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/djcbs.png" alt="New Query Wizard"></a></p>
  
  <p>When I click <em>From Oracle Database</em> I get the following error/message.</p>
  
  <p><a href="https://i.stack.imgur.com/6uC1O.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6uC1O.png" alt="Error"></a></p>
  
  <p>I can continue with my current provider, but when I actually try to connect to a database I get this:</p>
  
  <p><a href="https://i.stack.imgur.com/RwjUA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RwjUA.png" alt="Error"></a></p>
  
  <p>What I don't understand is why I'm getting this error when I have both 32-bit and 64-bit versions of Oracle 12c installed on my computer. Both are included on my <code>PATH</code> variable (32-bit first), and I also included a specific <code>ORACLE_HOME</code> and <code>TNS_ADMIN</code> to point to my 32-bit installation since my excel is 32-bit.</p>
  
  <p>I really want the ability to query from the database through Excel, but this problem is confusing me to death.</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>I've also just added the ODBC Driver from my Oracle home's into the ODBC Data Source Administrator Tool.</p>
  
  <p><a href="https://i.stack.imgur.com/JfINs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JfINs.png" alt="enter image description here"></a></p>
  
  <p>It's currently able to connect from this tool.</p>
  
  <p><a href="https://i.stack.imgur.com/QytOM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QytOM.png" alt="enter image description here"></a></p>
  
  <p>But when I try to connect to going through the <em>ODBC Connection</em> wizard, I know get this:
  <a href="https://i.stack.imgur.com/7xSJ2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7xSJ2.png" alt="enter image description here"></a></p>
  
  <p>Any Ideas?</p>