OLEDBProvider=prAuto

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
FredS
Posts: 272
Joined: Mon 10 Nov 2014 17:52

OLEDBProvider=prAuto

Post by FredS » Sat 16 May 2015 03:15

Hi,

With "SQL Server.OLEDBProvider=prAuto" how can we tell which provider is actually being used by the connection?

thanks

Fred

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: OLEDBProvider=prAuto

Post by azyk » Mon 18 May 2015 12:23

When the connection property TUniConnection.SpecificOptions.Values['SQL Server.OLEDBProvider'] is set to 'prAuto', this means that SQL Native Client provider will be used if it is installed on the client PC. Otherwise, UniDAC will use the standard OLEDB provider.

After establishing connection, you can learn the version number of the provider used by this connection from the TUniConnection.ClientVersion property value.

Post Reply