Hello -

Anyone have any thoughts on which API to use - ADO or ODBC?

I have a fat client written in C++ using MFC ODBC classes to access a Jet
database.
The app is going to be modified to write to a SQL Server central database
with multiple users accessing their local copies of the database ( using
replication technology on the clients side).

Most of the performance benchmarks give an edge to ODBC over ADO when
writing to an Access database. Anyone know of any benchmarks for a c/s
environment?

I've seen references that ADO has some client side cursor features for
filters and sorting which are a benefit over ODBC. I'd also like to use
the asynchronous fetch that OLE DB provides and am not sure if this is
implemented in ODBC.

Thanks for the help.

Bruce