Problem solve Get help with specific problems with your technologies, process and projects.

Connecting to an Oracle database through .NET

How do I connect to an Oracle database using Visual Basic/.NET?

I am a web designer and developer. How do I connect to an Oracle database using Visual Basic/.NET?
Oracle has made a real effort to make the database compatible with Microsoft's .NET. There are three basic ways to connect your .NET application to an Oracle database: ODBC, OLEDB and the Oracle Data Provider.

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.