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?