Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Advantage of OLE DB over SPT
Message
 
To
20/03/2006 11:52:30
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01105891
Message ID:
01105918
Views:
47
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform