Explanation of Cursor Types, Cursor Locations for Jet and SQL Server

Hello all,

I was hoping I could get some people to chime in here regarding the various
Cursor Types and locations available for working with Jet and SQL Server.
I also could use some feedback on which cursor location is preferable for
each. I have been doing a great deal of research and am still rather
confused about what cursor types to use in various situations.

I've reading some conflicting information regarding what is the best cursor
type and location to use when using Jet and SQL Server. For example, the
"Developer's Handbook" states that if an OLEDB provider only allows forward-
only cursors, that using the "adUseClient" location property will resolve
this and allow one to scroll throughout the recordset. I found this rather
odd, but I'm not an expert on this particular subject.

Any best practices ideas out there?

Thank you.