Update documentation please - prMSOLEDB is missing

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
mariot
Posts: 15
Joined: Mon 02 Feb 2015 11:35

Update documentation please - prMSOLEDB is missing

Post by mariot » Mon 24 Jun 2019 10:28

https://www.devart.com/unidac/docs/using-sqlserver.htm

In this documentation has "Provider" parameter values: prAuto, prSQL, prNativeClient, prCompact, prDirect.
I found that also new parameter value prMSOLEDB is operational, which is not mentioned in this documentation. Please update this document.

Please what is new description of prAuto parameter? Old/Present description is:
The default value. If the SQL Native Client provider is found, equals to prNativeClient, otherwise equals to prSQL.

Thanks,

Mario

Stellar
Devart Team
Posts: 304
Joined: Tue 03 Oct 2017 11:00

Re: Update documentation please - prMSOLEDB is missing

Post by Stellar » Wed 26 Jun 2019 08:04

Thank you for the information. We will add a description of prMSOLEDB provider to our online documentation.
prMSOLEDBSQL - Uses the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL). It should be installed on the computer to use this Provider value.
By default, the Provider property is set to prAuto. In this case, UniDAC will use one of the supported providers in such order:
1. prNativeClient;
2. prMSOLEDB;
3. prSQL;
First, UniDAC checks whether SQL Server Native Client is installed – if not found, then UniDAC searches for Microsoft OLE DB Driver for SQL Server. If SQLNCLI and MSOLEDBSQL are not installed on the machine, the driver uses Microsoft OLE DB Provider for SQL Server.

mariot
Posts: 15
Joined: Mon 02 Feb 2015 11:35

Re: Update documentation please - prMSOLEDB is missing

Post by mariot » Wed 26 Jun 2019 16:42

Thank you.

IMHO better order should be:
1. prMSOLEDB;
2. prNativeClient;
3. prSQL;

because SQLNCLI and SQLOLEDB is deprecated.

https://docs.microsoft.com/en-us/sql/co ... erver-2017

Mario

Stellar
Devart Team
Posts: 304
Joined: Tue 03 Oct 2017 11:00

Re: Update documentation please - prMSOLEDB is missing

Post by Stellar » Thu 27 Jun 2019 12:16

Unfortunately, we cannot implement this sequence because doing this would change the behavior of our components for existing users.

Post Reply