Let's say I have adTempus installed on a Windows 2003 Server, and that I want to create an ODBC data source for the adTempus MSDE database. Windows 2003 Server has a "SQL Server" ODBC driver, version 2000.86.2959.00, built in. Let's say for unrelated reasons, I also have the "SQL Native Client" ODBC driver, version 2005.90.3042.00, installed as well.
I was able to successfully create a data source and pull data using both driver versions. However can someone explain which driver version is most appropriate to use, and why? What are the risks involved with using one version versus another?