title: Excel VBA Connection to Oracle
body: <p>I am trying to connect to Oracle XE 11.2 using VBA and Excel. Oracle is installed on the same machine as Excel. I have also installed the 32 bit client tools. I have tried various methods found online but none of them seem to work.</p>
  
  <p>Per the suggestion on the post <a href="https://stackoverflow.com/questions/14836274/oledb-data-provider-can-not-be-found-vba-excel">OleDB Data provider can not be found VBA/Excel</a> I was able to create an ".udl" file that successfully connected. However when I used the connection string in my code I get the error "Provider cannot be found. It may not be properly installed".</p>
  
  <pre><code>Sub test2()
  Dim cn As ADODB.Connection
  Set cn = New ADODB.Connection
  cn.ConnectionTimeout = 99000
  cn.CommandTimeout = 99000
  cn.Open "Provider=OraOLEDB.Oracle.1;Password=Oracle!;Persist Security Info=True;User ID=SYSTEM;Data Source=DESKTOP-NAME"
  End Sub
  </code></pre>
  
  <p>I believe the problem is I don't have the right references selected but I have tried many combinations and can't find any that work. Any help would be appreciated. If I need a reference please list out the exact reference(s) names.</p>
  
  <p>Thanks,
  Scott</p>