<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Aug 19, 2016 at 4:11 PM, Tony Blomfield <span dir="ltr"><<a href="mailto:tonyb@precepthealth.com" target="_blank">tonyb@precepthealth.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-NZ" link="#0563C1" vlink="#954F72">
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-family:Calibri,sans-serif;font-size:11pt">I am pretty pissed that Embarcadero only support up
to SQL Server 2008, </span></p></div></div></blockquote><div><br></div><div>I think you'll find that they do support later versions.</div><div><br></div><div>In my reply the other day I forgot to say that I also use FireDAC to talk directly to an Azure SQL Instance (Which is very close to <span style="color:rgb(84,84,84);line-height:18.2px"> Microsoft </span><span style="font-weight:bold;color:rgb(106,106,106);line-height:18.2px">SQL</span><span style="color:rgb(84,84,84);line-height:18.2px"> Server 2016</span>).<br></div><div><br></div><div>It was exceedingly simple to do the connection.</div><div>Set the DriverID=MSSQL</div><div>then the server, database, username and password and it worked perfectly.</div><div><br></div><div>I then use either dataset components, or run direct queries, on the DB.<br></div><div><br></div><div>This was straight out of the box DX using a TFDConnection</div><div><br></div><div><br></div><div><br></div><div><br></div></div></div></div>