Devart Forums

I know that UniDAC uses several different methods to connect to a SQL Server database, depending on what is available. Is it possible via UniDAC to determine what connection method is used to connect to an SQL Server database.

What I want to do is detect if the native client is being used and if not display a message informing the user to install the native client. Is this possible?

Thanks,
Matt

To work with SQL Server, UniDAC uses either OLEDB or SQL Native Client provider. To make UniDAC use the SQL Native Client provider only, you should set the OLEDBProvider specific option to prNativeClient. Here is a code example:In this case, if there is no SQL Native Client provider installed on a computer, the "Required provider is not installed" error is generated.