title: SQL Server 2017 Ubuntu Ole Automation Procedures
body: <p>I installed and configured SQL Server 2017 on Ubuntu 16.04, with developer license. The installation works fine, I can connect to it with Management Studio as well, and restore databases from <code>.bak</code> files.</p>
  
  <p>But I can't find any solution, or alternative to use Ole Automation Procedures.</p>
  
  <p>The enable commands </p>
  
  <pre><code>sp_configure 'show advanced options', 1;  
  GO  
  RECONFIGURE;  
  GO  
  sp_configure 'Ole Automation Procedures', 1;  
  GO  
  RECONFIGURE;  
  GO  
  </code></pre>
  
  <p>returns this response:</p>
  
  <blockquote>
    <p>Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.<br>
    Configuration option 'Ole Automation Procedures' changed from 1 to 1. Run the RECONFIGURE statement to install.</p>
  </blockquote>
  
  <p>But when I try to use <code>sp_oacreate</code></p>
  
  <pre><code>EXEC @ret=sp_OACreate 'MSXML2.ServerXMLHTTP', @objectID OUT
  </code></pre>
  
  <p>I got 0 as <code>@ret</code> value, which means its OK, but also got error message on output:</p>
  
  <blockquote>
    <p>Could not load the DLL odsole70.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).</p>
  </blockquote>
  
  <p>Can someone suggest some workaround, or config tip please?</p>