most recent 30 from http://www.runsubmit.com 2010-09-09T11:50:21Z http://www.runsubmit.com/feeds/question/120 http://www.creativecommons.org/licenses/by-nc/2.5/rdf http://www.runsubmit.com/questions/120/what-differences-are-there-if-any-between-ole-db-and-odbc jay.l.stevens 2009-11-10T16:05:10Z 2009-11-11T23:22:12Z

<p>SAS/Access to OLEDB is a completely different product from SAS/access to ODBC. What, if any, are the differences between the two? Is there an advantage/disadvantage to using either?</p> <p>what are the syntax differences for invoking a libname with each for example?</p>

http://www.runsubmit.com/questions/120/what-differences-are-there-if-any-between-ole-db-and-odbc/121#121 Alan Churchill 2009-11-10T17:59:04Z 2009-11-10T17:59:04Z

<p>When given a choice, always pick OleDB. ODBC is the older access method that was replaced with OleDB. Speed-wise, they are about the same but oleDB has a lot less problems with drivers than ODBC does.</p> <p>Whenever I need the SAS syntax for an OleDB connection, I use my tool called SAS to SQL Converter (only runs on Windows, fyi).:</p> <p><a href="http://utilities.savian.net/" rel="nofollow">http://utilities.savian.net/</a></p> <p>It will call the Windows interface, allow you to make all of your choices and test your connection. It will then write the SAS libname statement for you. Hence, a GUI for doing OleDB connections.</p> <p>Alan</p>

http://www.runsubmit.com/questions/120/what-differences-are-there-if-any-between-ole-db-and-odbc/125#125 MarkLamias 2009-11-11T23:22:12Z 2009-11-11T23:22:12Z

<p>Generally OLEDB is the better choice. The choice depends on a number of factors to be considered, but I rarely see an instance where ODBC is justified over OLEDB. Here is a fantastic summary of the differences betwen ODBC and OLEDB connections as presnted at the SUGI 24: <a href="http://ftp.sas.com/techsup/download/v8papers/odbcdb.pdf" rel="nofollow">http://ftp.sas.com/techsup/download/v8papers/odbcdb.pdf</a></p>