The connection protocol is often decided by those that wrote the client software
and what they decided to develop their software in:
Roughly, but not exclusive or correct in all cases.
OLEDB - Probably a C or a C++ program
ADO - Visual Basic, MS Access
ADO.NET - Microsoft .NET programming language
ODBC - Some non-Microsoft development package
As was said. MS is just catering for the largest audience possible.