title: What driver used for connection to IBM Db2 with selected item 'Driver/Microsoft(requires .Net 4.5 or later' from Excel Data menu)?
body: <p>I can receive data from IBM Db2 into EXCEL via Driver named as 'Microsoft' from EXCEL menu Data/Get Data/From Database/From IBM Db2 Database/Advanced options.</p>
  
  <p>What driver is used to establish connection to Db2 in this case?</p>
  
  <p>How to establish such connection from VBA?</p>
  
  <p>In case IBM driver selected VBA code can be like:</p>
  
  <pre><code>Dim conn As Object
  Set conn = CreateObject("ADODB.Connection")
  conn.ConnectionString = "Driver=IBM DB2 ODBC DRIVER;UID=xxx;PWD=xxx;Protocol=TCPIP;Hostname=xxx.xxx.xxx.xxx;Port=9999;Database=xxx"
  </code></pre>
  
  <p>What I need to specify in ConnectionString corresponding to Driver Microsoft?<a href="https://i.stack.imgur.com/S5MaP.jpg" rel="nofollow noreferrer">Screenshot:</a></p>