[DUG] BERLIN and DB connectivity

[David Brennan]

Hi,

 

My understanding was the FireDAC was very up to date and had very good support for a wide range of databases, as well as a good range of features. We use ADO still so I don’t know for sure but it sounds odd.

 

Are you sure what you are testing is FireDAC?

 

Cheers,

David.

 

 

From: delphi-bounces at listserver.123.net.nz [mailto:delphi-bounces at listserver.123.net.nz] On Behalf Of Tony Blomfield
Sent: Friday, 19 August 2016 6:32 p.m.
To: NZ Borland Developers Group - Delphi List <delphi at listserver.123.net.nz>
Subject: Re: [DUG] BERLIN and DB connectivity

 

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>  [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/7286ffeb/attachment-0001.html