In my experience ODBC tended to be a little faster when dealing with iSeries, this may have changed in recent years. The following article has some benchmark data for OLEDB vs ODBC.
http://www.redbooks.ibm.com/abstracts/SG245183.html?Open>OLE DB is supposed to be faster and consume fewer resources than ODBC (which is used by SPT).
>
>Disadvantage is that the results are returned in an ADO record set and may need to be converted to a cursor before use in VFP.
>
>>What are the advatages of using OLE DB over SPT and what does it require?
>>
>>I main objective is getting and putting data to an iSeries(AS400) database.