|
2
1
|
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? what are the syntax differences for invoking a libname with each for example? |
||
|
|
|
3
|
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. Whenever I need the SAS syntax for an OleDB connection, I use my tool called SAS to SQL Converter (only runs on Windows, fyi).: 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. Alan |
||
|
|
|
1
|
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: http://ftp.sas.com/techsup/download/v8papers/odbcdb.pdf |
||
|
|
