The oldest and most common connection is the ODBC connection. You can connect applications, Excel, even Access using ODBC.
OLEDB builds on the ODBC connection to provide additional functionality. I am seeing a lot of applications implementing OLEDB lately.
However, like with Java, if you want the most functionality and performance you need to use the connection built by Oracle, in this case the Oracle Data Provider for .NET or ODP. This connection provides the best performance because there is no translation layer as with ODBC or OLEDB.
All three connections work with any of the .NET languages.
Dig Deeper on Oracle Application Server
Related Q&A from John Garmany
I get the ORA-12541 error message when I try to connect through Forms6i and Reports6i Builder. I've started the listener. I have no problems ... Continue Reading
I am facing the ORA-04076 error. I googled the error but was unable to understand it. What exactly do I need to do to solve this? I am using Toad. Continue Reading
We are using Oracle Database. In our client site, we have 500 users using the database at one time. Sometimes the database objects become invalid ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.