Comparison of different techniques

[srinika]

Can some guru Differentiate the following (Mainly with regard to, can any of these be used independent of the other) and the normal situation of using each;
1. ADO
2. ODBC
3. OLEDB
4. Data Environment
A brief Description would be enough
Regards
Srinika

[ilynx]

actually they are not connected to each other.

1. ADO - ado is a library of different stuffs use to connect, manipulate, and browse to different database.
2. ODBC - a portal to different connections. may i can consider this as the middle component between the application and the connection.
3. OLEDB - a direct connection to a certain type of database.
4. Data Environment - a built in data source in vb. not recommended to use it consumes lot of memory. data environment is for lazy ones.

[srinika]

OK
Aren't v to use ODBC's DSN in ADO and OLEDB? Is this optional or a must?
(ie. can v disregard ODBC & make a connection to a database in a different machine ?)

Note:
I have used ADO with ODBC connection created manually via the control panel, and did some programs.

And to be added to the earlier set of Items, what is Jet Database Engine?

I'm not looking for the definitions but wanting to know the relationship / need of each item in database programming.

[ilynx]

in VB program you use ado to connect to ODBC or OLEDB. make sense? not all database types are supported in oledb and it is so hard to make changes in databases when u use that one. odbc can be changed to any setting you want.

jet database engine - is like oledb. but it is use to open access database types (and other dbf formats, i guess)