Using NativeClient for MSConnection provider

[ptashakori]

Hi there,

We are currently using SDAC version 5. Using TMSConnection component to connect to Sql Server, we've used prAuto as provider so far.
We've faced a situation that connection must be provided by Sql Server Native Client 11.0 for the sake of encryption. When MSConnection.Options.Provider is set to prNativeClient, connect method fails with "Reqiured provider is not installed" error.

This is despite the fact that in odbc drivers, I do see Sql Server Native Client 11.0. Following this old thread viewtopic.php?t=24732#, I tried manually adding Provider to Connection string
Provider=SQLNCLI11
Or
Provider=SQLNCLI11.0
And for both values, I got "Bad Parameter Value" error.

I use Windows 7 and ODBC drivers show
(Name - File) SQL Server - SQLSRV32.DLL
and
(Name - File) SQL Server Native Client 11.0 - SQLNCLI11.DLL
Target database is Sql server 2012.

Is this related to using old version of SDAC?
Thanks in advance for your help,
Parisa

[azyk]

SDAC 5 does not support SQL Server Native Client 11. This possibility was implemented in SDAC 6.2.7 on 21-Jun-12: https://www.devart.com/sdac/revision_history.html

To solve the issue, please upgrade SDAC to the version 6.2.7 or the latest one.

[ptashakori]

Thanks azyk!

I will try it with version 8.0.3.

Parisa