What driver to use for ODBC connection from Windows 10 host to SQL Server 2014? I have a choice of 3 SQL Server clients:
- ODBC Client 11
- SQL Server
- SQL Server Native Client.
I've tried the ODBC client and the native client they both seem to work.
Is there any reason to prefer one over the others?