Oracle ODBC Drivers from Oracle vs. Microsoft

pts.
Tags:
Development
Oracle development
VB.NET
Visual Basic
I am wrestling with whether Microsoft products (e.g., Excel-MS Query) that use ODBC to access Oracle databases would benefit more by using the latest driver from Oracle or Microsoft. If using a driver from Microsoft, is it likely to be significantly less efficient in exploiting the latest features of the Oracle database (which continues to advance dramatically)? If using a driver from Oracle, is it likely to be significantly less efficient in exploiting the latest features of the Microsoft software? If there are significant tradeoffs, what are they? What is likely to be the best choice?

Answer Wiki

Thanks. We'll let you know when a new response is added.

I would use the Oracle native drivers. I have had issues with using Microsoft drivers to access oracle. Especially do not use MS Access to connect to Oracle, because Access will lock tables. You might want to check with your DBA as well to make sure you are not locking tables, records.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Oracle ODBC Drivers from Oracle vs. Microsoft (Q/A) | Seek The Sun Slowly
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/oracle-odbc-drivers-from-oracle-vs-microsoft/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: