https://communities.sas.com/t5/SAS-Procedures/Accessing-an-Oracle-Database-from-SAS-on-Microsoft-Windows/m-p/8877#M484 This paper describes three ways to access ORACLE tables: SAS/Access Interface to Orace, ODBC, OLE DB.<BR /> <A href="http://support.sas.com/techsup/technote/ts703.pdf" target="_blank">http://support.sas.com/techsup/technote/ts703.pdf</A><BR /> <BR /> Is there a performance difference among these three methods? Wed, 08 Jun 2011 04:32:04 GMT MarcTC 2011-06-08T04:32:04Z https://communities.sas.com/t5/SAS-Procedures/Accessing-an-Oracle-Database-from-SAS-on-Microsoft-Windows/m-p/8877#M484 This paper describes three ways to access ORACLE tables: SAS/Access Interface to Orace, ODBC, OLE DB.<BR /> <A href="http://support.sas.com/techsup/technote/ts703.pdf" target="_blank">http://support.sas.com/techsup/technote/ts703.pdf</A><BR /> <BR /> Is there a performance difference among these three methods? Wed, 08 Jun 2011 04:32:04 GMT https://communities.sas.com/t5/SAS-Procedures/Accessing-an-Oracle-Database-from-SAS-on-Microsoft-Windows/m-p/8877#M484 MarcTC 2011-06-08T04:32:04Z https://communities.sas.com/t5/SAS-Procedures/Accessing-an-Oracle-Database-from-SAS-on-Microsoft-Windows/m-p/8878#M485 Yes.There are some different.<BR /> I recommend to use SAS/Access which is more efficient because you can pass sql code to Oracle DBMS by Pass-Through method to use highly oracle resource, and you can also have several sessions at one time, However ODBC has only one session at one time .<BR /> About OLE DB ,not familiar.<BR /> <BR /> <BR /> Ksharp Wed, 08 Jun 2011 07:48:12 GMT https://communities.sas.com/t5/SAS-Procedures/Accessing-an-Oracle-Database-from-SAS-on-Microsoft-Windows/m-p/8878#M485 Ksharp 2011-06-08T07:48:12Z https://communities.sas.com/t5/SAS-Procedures/Accessing-an-Oracle-Database-from-SAS-on-Microsoft-Windows/m-p/8879#M486 Doesn't ODBC also allow pass-through query? Wed, 08 Jun 2011 15:22:42 GMT https://communities.sas.com/t5/SAS-Procedures/Accessing-an-Oracle-Database-from-SAS-on-Microsoft-Windows/m-p/8879#M486 MarcTC 2011-06-08T15:22:42Z https://communities.sas.com/t5/SAS-Procedures/Accessing-an-Oracle-Database-from-SAS-on-Microsoft-Windows/m-p/8880#M487 ODBC also allow pass-through query.<BR /> But I still prefer to SAS/Access. <BR /> whatever ,if you want to know more about these, the best way is to chech documentation.<BR /> <BR /> Ksharp Thu, 09 Jun 2011 02:25:58 GMT https://communities.sas.com/t5/SAS-Procedures/Accessing-an-Oracle-Database-from-SAS-on-Microsoft-Windows/m-p/8880#M487 Ksharp 2011-06-09T02:25:58Z