topic Re: SQL Native Client vs. OLD DB Provider for SQL Server in Data Management Questions https://community.esri.com/t5/data-management-questions/sql-native-client-vs-old-db-provider-for-sql/m-p/665608#M37708 <HTML><HEAD></HEAD><BODY><SPAN>Thanks very much!</SPAN></BODY></HTML> Thu, 02 Aug 2012 15:02:02 GMT JohnNerge 2012-08-02T15:02:02Z SQL Native Client vs. OLD DB Provider for SQL Server https://community.esri.com/t5/data-management-questions/sql-native-client-vs-old-db-provider-for-sql/m-p/665606#M37706 <HTML><HEAD></HEAD><BODY><SPAN>I have three related questions about the two OLD DB connection types listed in the subject line of this post:</SPAN><BR /><SPAN>1) What is the difference between them?</SPAN><BR /><SPAN>2) Is one newer/superior to the other?</SPAN><BR /><SPAN>3) If yes for question two, then why and when would I use one over the other?</SPAN><BR /><BR /><SPAN>Thanks in advance for any info,</SPAN><BR /><SPAN>John Nerge</SPAN></BODY></HTML> Wed, 01 Aug 2012 20:48:38 GMT https://community.esri.com/t5/data-management-questions/sql-native-client-vs-old-db-provider-for-sql/m-p/665606#M37706 JohnNerge 2012-08-01T20:48:38Z Re: SQL Native Client vs. OLD DB Provider for SQL Server https://community.esri.com/t5/data-management-questions/sql-native-client-vs-old-db-provider-for-sql/m-p/665607#M37707 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote"><BR />1) What is the difference between them?<BR />2) Is one newer/superior to the other?<BR />3) If yes for question two, then why and when would I use one over the other?<BR /></BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>They are both OLE DB providers shipped by Microsoft. The SQL Server OLE DB driver has been deprecated for a while, in favor of the SQL Native Client, which contains both OLE DB and ODBC drivers in one. The OLE DB provider is really only available for backward compatibility.</SPAN><BR /><BR /><SPAN>-Shannon</SPAN></BODY></HTML> Thu, 02 Aug 2012 14:56:41 GMT https://community.esri.com/t5/data-management-questions/sql-native-client-vs-old-db-provider-for-sql/m-p/665607#M37707 ShannonShields 2012-08-02T14:56:41Z Re: SQL Native Client vs. OLD DB Provider for SQL Server https://community.esri.com/t5/data-management-questions/sql-native-client-vs-old-db-provider-for-sql/m-p/665608#M37708 <HTML><HEAD></HEAD><BODY><SPAN>Thanks very much!</SPAN></BODY></HTML> Thu, 02 Aug 2012 15:02:02 GMT https://community.esri.com/t5/data-management-questions/sql-native-client-vs-old-db-provider-for-sql/m-p/665608#M37708 JohnNerge 2012-08-02T15:02:02Z