>ODBC is old technology and not suited for n-tier solutions. How do you get the >data from the middle tier to the application? ADO uses COM and passes the data >in a recordset.

As Rod has pointed out - this is not really correct. Yes, ADO makes it easy to pass recordsets around - but quite a bit can be accomplished with plain old SPT.


>ADO uses OLE-DB. OLE-DB is a low-level data access mechanism. ADO is a high->level interface to OLE-DB. OLE-DB has many advantages over ODBC. It can access >all types of data. You'll see an OLE-DB provider for Exchange.
>The nice thing is, that the interface to the data will always be the same, no >matter what the back end data is. ODBC calls can vary depending on the back >end data.

The ADO interface is the same. The capabilities on the other hand, may be different. It all depends on the provider.