Hello!
I recently began development of a new Access application that leverages MS SQL as a backend. I have become accustomed to selecting the 'SQL Server Native Client 11.0' as the driver when linking tables in Access. I know that at one time, this was highly recommended by some, even though it requires a separate software installation on the endpoints. Today when creating the linked tables, I noticed some options that I don't recall seeing before when creating a new DSN for connection. The new previously unnoticed options include 'CR SQL Server Classic Wire Protocol ODBC Driver 7.1.5' and 'CR SQL Server Native Wire Protocol ODBC Driver 7.1.5'. So my questions are several:
1) Are these new options or have I just not noticed them until now? If so, when did they come out?
2) What are the advantages and disadvantages of each of these 'new' drivers when compared to each other?
3) What are the advantages and disadvantages of these 'new' drivers compared to the SQL Server Native Client 11.0 Driver?
4) What do you feel the best driver to use is in 2021 and why?
I make extensive use of the VBA, DAO, Access, Office, Excel and Outlook libraries in my code, if that makes any difference as to what the 'correct' answer is.
Thank you for taking the time to read my post and I'm hoping someone here can shed some light on this subject for me.
Thanks!!!