Performance of ODBC vs. other access methods

Tom,

You wrote:

"I think it does answer your question, although it isn't an answer that
helps
much.

I interpret "it depends" to mean that there is no prevailing wisdom.  I
give
that answer a lot of credence because it was offered by several
luninaries
in the community.

Obviously, if I am interpreting incorrectly I hope someone will correct
me."

No, it doesn't answer the question at all as it doesn't speak to ODBC
vs.(means comparison) other access methods at all.   Instead, it speaks
to indexing strategies and what function I might be doing.

What I expected to here, as I've heard from others in the industry, is
based on each individual's experience, a comparison between access
methods (on the access methods mentioned and any others they'd like to
compare) from slowest to fastest; of course,  with the caveat of all
things being equal (of course my milage may vary depending on database
performance).   Then I expected, as is OFTEN done on this and other
forums,  example "war stories and fairy tales" of experiences with each
type of access method if they had them.   And, on and on, as has been
the characteristic with all the folks on here that are willing to share
their experiences.    

I think you are right about one thing... there is no prevailing wisdom
on this subject.  Perhaps I'm on the wrong forum.

Take care,

Dave