title: Excel VBA to SQL Server 2016 Connection String Error
body: <p>We´re trying to get VBA access to our native server database with the plugin ADODB in Excel. However, we´re running into the same error message no matter what connection string configuration we´re trying.</p>
  
  <p>Any help would be appreciated! See below image and code.</p>
  
  <pre><code>Sub test()
  
      Set Conn = New ADODB.Connection
      ConnString = "Provider=SQLOLEDB;Data Source=databaseb006;Database=EIU"
      Conn.Open
  
  End Sub
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/FdiKw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FdiKw.png" alt="enter image description here"></a></p>