They are both means to accomplishing an end (communicating with a database). ADO can use both. OLEDB is the, current, access method of choice. ODBC is older technology that will, eventually be phased out.

At this point in time, I would use ADO and select the access method that works best for you (but use ODBC only if you cannot, or with great difficulty, accomplish the task with OLEDB).