Tradeoffs with OLEDB

[Tomaz Stih]

With several database technologies available is it a good strategic decision to go to OLEDB for consistency sake. This way all developers can use same engine and also OLEDB provides same (all)functionallity DAO and RDO do.
Is there a good reason not to use the ADODB object and to use something else instead? Are the tradeoffs worth the consistency?

---------------------------------------------
Tomaz Stih, B.Sc.CS tomaz@nameco.com
Ob sotoccju 10 Nameco Group
SI-1000 Ljubljana http://www.nameco.com
Europe

I am trying to learn the OLEDB. But I found it not possible to get an Interface of IRowsetIndex in the MSJet 4.0 provider. Hence I am not able to do SEEK function without that. I can not find any documentation on the MSJET provider on what it has and what it does not support. Any thoughts?

hshliang@hotmail.com