OLE DB is a data access technology. A bit of history may help...

ODBC was developed to access relational data. It's not so good at non-relational data. It's also a pig. It uses lots of resources.

OLE DB was developed to access any type of data, even text files. It uses fewer resources and generally is faster than ODBC. However, the only people that will use OLE DB directly are C++ programmers. ADO is a high-level wrapper around OLE DB that allows non-C++ developers to use OLE DB.

ADO does not return Fox cursors. It returns record sets, which are COM-based data objects. With VFP 8, you can use the CursorAdapter to automatically convert ADO to a Fox cursor.

More info on ADO with VFP can be found at http://msdn.microsoft.com/library/en-us/dnfoxgen/html/adojump.asp?frame=true


>Hi, every body. I know I got the atention of some of you with the subject. God, because I really need and advise or better well said some guidence.
>
>I have heard a lot about OLE DB stuff, I saw the excitment when the OLE DB provider for VFP8 was out to the market. BL gave me the idea of using this thing to solve a problem I got. But honestly, I don't know what is this for. I don't know how to use it and I don't know the capabilities it has.
>
>Also i noticed in the little info I got that works with ADO, is this the only way, or it is a native way to do it?
>
>So, what I am asking here is links, explanations, examples, advantages, disadvantages of this technology.
>
>thks a lot