title: Can MS OleDB driver for ORACLE do UPDATES
body: <p>Has anyone used the MS OLEDB Driver to update an Oracle Database?</p>
  
  <p>I have been coerced into (paid) doing some excel 2013 vba development. </p>
  
  <p>We are trying to port a system from SQL server to ORACLE. </p>
  
  <p>The queries are all working fine using the MS OLEdb driver for ORACLE. 
  Here is the connection string...</p>
  
  <pre><code>Global Const ConnectionString = "Provider=MSDAORA.1;Data source=orclServer1;User ID=myReportingId;password=BigBoy;"
  </code></pre>
  
  <p>This works fine for queries. When you do updates, excel just wanders off into the weeds and goes catatonic. </p>
  
  <p>I can use the ORACLE driver and it works fine. The problem is now all the spreadsheet users have to install the ORACLE CLIENT. </p>
  
  <p>The MSDN page for the driver has some ominous things to say. Basically the driver is on its way out.  There is also a comment about only supporting static,read-only cursors, but its in a paragraph that is somewhat confusing. I wonder to myself is that a continuation of the discussion on joins, or a general statement? </p>
  
  <p><a href="https://msdn.microsoft.com/en-us/library/windows/desktop/ms675851%28v=vs.85%29.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/windows/desktop/ms675851%28v=vs.85%29.aspx</a></p>
  
  <p>We have options, but thought I would reach out to this most excellent support community and see if anyone had a solution. </p>
  
  <p>We are really trying to do a zero install type thing. So, .Net libraries, etc are all off the table. If there has to be an install, we will just require the ORCL client. </p>
  
  <p>just sort of hoping there is some obscure option i can include in the connection string or set on the connection/command object. </p>
  
  <p>for the sake of completeness, here is the vb code that I am using to attempt the update. Again, this works w/ the MS SQL SERVER oleDB provider and ORACLE's oleDB provider, just not the MS ORACLE oleDB driver. </p>
  
  <pre><code>Public Sub ExecuteUpdateQuery(qry_str As String)
  
  Dim cnn As New ADODB.Connection
  
  With cnn
      'constant defined above...
      .Open ConnectionString
  
      .Execute (qry_str)
      .Close
   End With
   End Sub 
  </code></pre>
  
  <p>thanks...</p>
  
  <p>greg</p>