Very Computer

I am currently working on a database application.  The classes that
access data, are using ODBC to access an MS Access Db or an identical Db
in SQL Server 2000.  We know we need to use a more current technology,
but which one.  What are the pros and cons of using OLE DB vs ADO.
Currently, The Data Access dll uses structures to pass data back and
forth.  We will be moving these classes into Com a Server in the next
version.  I am familiar with both data access technologies, but by no
means an expert in either.  The decision also includes climbing a
learning curve.  Not a problem, but I don't want to get to the top of
that curve to find I climbed the wrong one.  One more question, are the
sweeter abilities of ADO (.save, URL in a connection, ...) available in
OLE DB, or do they have to be coded?

Thank you

Quote:-----Original Message-----

I am currently working on a database application.  The classes that
access data, are using ODBC to access an MS Access Db or an identical Db
in SQL Server 2000.  We know we need to use a more current technology,
but which one.  What are the pros and cons of using OLE DB vs ADO.
Currently, The Data Access dll uses structures to pass data back and
forth.  We will be moving these classes into Com a Server in the next
version.  I am familiar with both data access technologies, but by no
means an expert in either.  The decision also includes climbing a
learning curve.  Not a problem, but I don't want to get to the top of
that curve to find I climbed the wrong one.  One more question, are the
sweeter abilities of ADO (.save, URL in a connection, ...) available in
OLE DB, or do they have to be coded?

Thank you

.

ADO is Microsoft's primier data access technology. It's designed as an
easy-to-use application interface to OLE DB. ADO is easy to use because it
exposes Automation objects that abstract the OLE DB interface. This allows
the programmer to focus on the tasks to accomplish rather than the
complexity of OLE DB.

ADO is designed to present the most commonly used feature of OLE DB.
However, if you want to use the full feature of OLE DB, for example, you
want to build a OLE DB provider, OLE DB should be used.

If you just want to access data from a database, you should use ADO.