topic Multiple Versions of SQL Drivers - How does Arc Decide? in Data Management Questions https://community.esri.com/t5/data-management-questions/multiple-versions-of-sql-drivers-how-does-arc/m-p/371408#M21090 <HTML><HEAD></HEAD><BODY><P>We have multiple SQL geodatabase servers that we connect to with Arc Map 10.3.1, ranging from SQL 2008R2 to SQL 2016.&nbsp; We can't control the versions of the SQL servers, some of them are at client sites.&nbsp;&nbsp; Our users' workstations currently have at a minimum the SQL Native client 11 and ODBC 13 drivers installed.&nbsp; I am having some trouble getting Arc to pick the right driver for the server version being connected to.&nbsp;&nbsp; We need to use ODBC for 2014 and 2016, but Native Client to connect to 2012 and 2008 servers. </P><P></P><P>We have other applications that require Native Client so we can't just remove it.</P><P></P><P>Is there a way to get Arc products to use the driver that matches the server?&nbsp;&nbsp; I only see a choice for picking SQL, not which version of SQL or which driver.</P></BODY></HTML> Tue, 04 Apr 2017 08:05:19 GMT DaveRutledge 2017-04-04T08:05:19Z Multiple Versions of SQL Drivers - How does Arc Decide? https://community.esri.com/t5/data-management-questions/multiple-versions-of-sql-drivers-how-does-arc/m-p/371408#M21090 <HTML><HEAD></HEAD><BODY><P>We have multiple SQL geodatabase servers that we connect to with Arc Map 10.3.1, ranging from SQL 2008R2 to SQL 2016.&nbsp; We can't control the versions of the SQL servers, some of them are at client sites.&nbsp;&nbsp; Our users' workstations currently have at a minimum the SQL Native client 11 and ODBC 13 drivers installed.&nbsp; I am having some trouble getting Arc to pick the right driver for the server version being connected to.&nbsp;&nbsp; We need to use ODBC for 2014 and 2016, but Native Client to connect to 2012 and 2008 servers. </P><P></P><P>We have other applications that require Native Client so we can't just remove it.</P><P></P><P>Is there a way to get Arc products to use the driver that matches the server?&nbsp;&nbsp; I only see a choice for picking SQL, not which version of SQL or which driver.</P></BODY></HTML> Tue, 04 Apr 2017 08:05:19 GMT https://community.esri.com/t5/data-management-questions/multiple-versions-of-sql-drivers-how-does-arc/m-p/371408#M21090 DaveRutledge 2017-04-04T08:05:19Z