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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • RNJ509
    [...] 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following