title: Unable to connect Teradata server with authentication mechanism as LDAP
body: <p>It would be a great help if anyone provides a VBA connection string to connect Excel with Teradata where Authentication mechanism = LDAP.</p>
  
  <p>VBA code used before configuring Authentication mechanism = LDAP is given below. But the code doesn't work when my organisation moved our credentials to support only AUTHENTICATION MECHANISM = LDAP.
  Please help!</p>
  
  <p>Code:</p>
  
  <pre><code>Public cn As ADODB.Connection
  Public rs As ADODB.Connection
  
  Sub test_ter() 
      TDCONSTR1 = "DSN &amp;_ =&lt;dsn_name&gt; ; uid = &lt;usr&gt;; PWD = &lt;PWD&gt;;" 
      Set cn = new ADODB.Connection     
      cn.Open TDCONSTR1
      MsgBox("Connection established")
  End Sub
  </code></pre>