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.