OLE DB is COM based, ODBC isn't.
OLE DB exposes a much richer programming interface and is better with
tractions, if you ask me. However, in general ODBC is quite a bit faster
than OLE DB. Please note that it really depends on the underlying provider
or driver, but with MS Access, I would probably go with the OLE DB provider,
unless you have loads of data to process...
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
