25 Jan 98
ADO: routine access to data. Seen as vehicle of choice for VB developers.
OLE DB: lower level COM-based access to data. Used by provider developers. Performance comparable to ODBC. Adds an OPENROWSET function to be used in FROM clause. This is supported in views and most users will create views so that the SELECT statements dont get littered with OPENROWSET.
ODBC: Not going away. "Going to be around for a long time". Has new 7.0 data types. There is a DSN wizard and password encryption. ODBC round-trips are minimized for Internet access.
DBLIB: not improving. No access to 7.0 features.
DMO: The new DMO is not backward compatible with the old DMO. It is a different OLE Object. It accesses the database through ODBC, not through DBLIB as the 6.x version does.
Many thanks to Sharon for providing these notes - drop her a note at email@example.com and tell her thanks!