Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Why is MS SQL Server Native Client preferred over newer ODBC drivers?


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: Nov 12, 2017 11:58 AM Last Post By: Dmitry Arefiev Threads: [ Previous | Next ]
Lars Sondergaard

Posts: 1
Registered: 5/16/97
Why is MS SQL Server Native Client preferred over newer ODBC drivers?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 11, 2017 9:04 AM
In Delphi 10.2.1 support for the ODBC DRIVER 13 FOR SQL SERVER has been added.

However, in TFDPhysMSSQLDriver.InternalLoad when calling FindBestDriver the older SQL SERVER NATIVE CLIENT 11.0 is listed as preferred over the newer ODBC driver if both are present.

Is there a reason for this, or is this "better safe than sorry" to stick with the older one?
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Why is MS SQL Server Native Client preferred over newer ODBC drivers?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 12, 2017 11:58 AM   in response to: Lars Sondergaard in response to: Lars Sondergaard
ODBC Driver for SQL Server fails to work correctly with Table Valued Parameters. Also, it has one more issue, which I cannot remember.

--
With best regards,
Dmitry
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02