Adodb works with MS-based databases such as Sql Server.

Oledb is a standard format supported by a large number of dbs, so you can connect to oracle, db2 etc. using Oledb.

You can also use oledb to connect to Sql Server but the performance is lower as compared to a adodb connection which is optimized to work with Sql Server and MS Access.