You're assuming that the technologies are mutually exclusive, whilst I'm not even sure that they are really competing technologies. ODBC puts it priority in talking to as much databases as it can, whilst ADO puts it's coins on speed. ADO.NET is the speedy version that has been integrated in our favorite framework. Nah, ODBC ain't dead. The BDE is dead, and I think that we should be gratefull for that :)
I are troll :)