[DUG] BERLIN and DB connectivity

[Tony Blomfield]

To make it clearer. IT only supports Native Client 10.0. This means some features on later versions of SQL server are still supported, but who knows which ones ?  I don’t want to find out the hard way which features are not supported. I am disappointed that E over promises and under delivers.

Cheers,

T

From: delphi-bounces at listserver.123.net.nz [mailto:delphi-bounces at listserver.123.net.nz] On Behalf Of Barry Neale
Sent: Friday, 19 August 2016 4:24 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] BERLIN and DB connectivity



On Fri, Aug 19, 2016 at 4:11 PM, Tony Blomfield <tonyb at precepthealth.com<mailto:tonyb at precepthealth.com>> wrote:
I am pretty pissed that Embarcadero only support up to SQL Server 2008,

I think you'll find that they do support later versions.

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  Microsoft SQL Server 2016).

It was exceedingly simple to do the connection.
Set the DriverID=MSSQL
then the server, database, username and password and it worked perfectly.

I then use either dataset components, or run direct queries, on the DB.

This was straight out of the box DX using a TFDConnection




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20160819/7c561aa6/attachment.html