When setting up a new connection to the SQL Server data I am reporting on I enter
the "Crystal Reports" menu then "Database" menu pad then "Database Expert".
At this point I connect to the data using ODBC(RDO).
The reports pull the data correctly.

I've noticed two other options, namely, OLE DB(ADO) and ADO.NET. What are the pros and cons of these various methods of establishing a data connection.

Are these other two methods better than ODBC(RDO)?