title: Connect to LocalDB with new ODBC Driver for SQL Server
body: <p>UPDATE: Thanks to Dan Guzman, the problem has been solved.
  I'd made a mistake and used the old legacy <code>Driver={SQL Server};</code> assuming it is the new driver. Instead, I should have used <code>Driver={ODBC Driver 11 for SQL Server}</code> which is the actual new ODBC driver.
  I can connect to <strong>(Localdb)\v11.0</strong> with the new driver.</p>
  
  <hr>
  
  <p><strong>TL;TR</strong>: Why I can not connect to <strong>(Localdb)\v11.0</strong> using the new <code>Driver={SQL Server};</code> in connection string, but I can connet if I switch the driver to the old <code>Driver={SQL Server Native Client 11.0};</code> ?</p>
  
  <p>The remaining connection string parameters I use are (if used in C++ code, backslash escaped):</p>
  
  <pre><code>Server=(localdb)\v11.0;Integrated Security=True;
  </code></pre>
  
  <p>I'm trying to access SQL Server via ODBC and calling <code>SQLDriverConnect</code> with DSN-less connection string. If I switch the driver to <strong>SQL Server Native Client 11.0</strong>, then I suddenly can connect.</p>
  
  <p>I have also tested generating FILEDSN using <code>%systemdrive%\Windows\System32\odbcad32.exe</code> and I observed exactly the same issue.</p>
  
  <p>The only local database I can connect with the new <code>Driver={SQL Server}</code> is <code>Server=DEVBOX\SQLEXPRESS</code> (if used in C++ code, backslash escaped, of course).</p>
  
  <p>I couldn't find any confirmation that the new ODBC Driver for SQL Server does not support LocalDB.</p>
  
  <p>It is only indicated in the FAQ of <a href="https://technet.microsoft.com/en-us/library/hh568451.aspx" rel="nofollow">ODBC Driver for SQL Server for Linux</a></p>
  
  <blockquote>
    <p>Which features of SQL Server 2012 does this version of the driver
    support?
        The ODBC driver on Linux supports all server features in SQL Server 2012 except LocalDB.</p>
  </blockquote>
  
  <p>How can I connect to LocalDB with the new ODBC driver on Windows?</p>
  
  <p>UPDATE:
  I'm using Windows 10 Pro + VS2015.
  I can connect to both, <code>(localdb)\v11.0</code> and <code>DEVBOX\SQLEXPRESS</code> with SQL Server Management Studio 2016 (CTP).
  (The same question has been asked on MSDN Forums, <a href="https://social.msdn.microsoft.com/Forums/en-US/8fc36948-3792-4d1d-93df-91186d81a784/connecting-to-localdb-with-new-odbc-driver-for-sql-server" rel="nofollow">here</a>.)</p>