Using NativeClient for MSConnection provider

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ptashakori
Posts: 3
Joined: Tue 01 Apr 2008 14:55

Using NativeClient for MSConnection provider

Post by ptashakori » Thu 12 Oct 2017 18:19

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
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Using NativeClient for MSConnection provider

Post by azyk » Fri 13 Oct 2017 07:20

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
Posts: 3
Joined: Tue 01 Apr 2008 14:55

Re: Using NativeClient for MSConnection provider

Post by ptashakori » Fri 13 Oct 2017 14:55

Thanks azyk!

I will try it with version 8.0.3.

Parisa

Post Reply