what's difference between ADODB , ODBC , OLEDB ?

[suryo]

what's difference between ADODB , ODBC , OLEDB ? and how about the compatibility each other with database ? support all database or only few ?

plzz tell me , i'm really blind of this >.<

 

[JohnH]

ODBC and OLEDB is communication drivers, ADO is an interface. .Net uses the ADO.Net technology for interface, and has built in support to access multiple sources including SQL and Oracle servers, OLEDB and ODBC.

 

[suryo]

thx sir ^^ , it's really helpfull