Devart Forums

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

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.

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

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