>- OLEDB goes through the COM layer. It's very likely faster and uses less memory to go through ODBC > >- Microsoft is dropping OLEDB. At some point they won't update the Jet OLEDB Provider. Then you'll either a) be forced to stay with older versions or b) Be in crisis mode trying to rewrite for ODBC.
Dropping OleDb? I hadn't heard that. I always thought that OleDb was preferable to ODBC!! Do you mean just for the Jet provider or all? The Sql Server provider is OleDb ... are you saying that's going away too?!?!