Difference between DAOs, RDOs and ADOs in VB 6.0

[Pushyamitra]

Hi,

Could someone please give me the differences between the different database connectivity procedures in VB 6.0

Thanks in Advance,

Mitra.

[si_the_geek]

Welcome to VBForums!

I'll start by intentionally ignoring two of the options... DAO and RDO are both officially obsolete, so you should not even consider using them (as you cannot be sure they will work on other computers).

That leaves ADO, which is safe (for about as long as VB6 is anyway!). There are basically two options within ADO, one is to use the ADODC control and the other is to use code (ADODB). Using the control is a bad idea, for some of the reasons see the "why bound controls are bad" article in our Database FAQs (at the top of this forum, or link below).

This means that the only 'sensible' option is to use ADO code, an example of which can be found in the "ADO Tutorial" from our Database FAQs (or via the direct link in my signature).

[Pushyamitra]

Thanks for the quick response.

However, could you please give me some description regarding DAOs and RDOs along with their functionality. The title that I gave was the question asked to me in an interview.

If possible could you please provide me the list of FAQs on VB 6.0 along with answers.

Thanks,
Mitra.

[szlamany]

As SI said - it doesn't really matter much anymore...

But if you want to know what all those protocols were here's an old thread that discusses it.

http://www.vbforums.com/showthread.p...ight=ado+oledb

[salvelinus]

DAO is fine for working only within Access, at least up to Access 2K or 2K2, never used it beyond that. If you use anything else to work with Access data, VB6 for example, use ADO. ADO.Net if you're using VB.Net.