CODEWITHSUNDEEP
vb.netoracle-databaseoledbodp.net
Riddari
Riddari

Reputation: 1771

What are the differences between using OLEDB and ODP.NET to connect to an Oracle database?

I have two small VB.NET applications that connect to the same Oracle database. One uses the OLEDB provider, and the other uses Oracle's ODP.NET. Should I expect to see problems with the OLEDB provider, as it's less 'native' to Oracle?

Thanks for any help!

Upvotes: 1

Views: 2607

Answers (1)

WaldiMen
WaldiMen

Reputation: 377

OLEDB was designed for accessing generic databases, ODP.NET is native Oracle provider which should have better performance and allows to use specific Oracle features.

Upvotes: 1

Related Questions