Use 'Oracle Provider for OLE DB' from .NET using OleDbConnection

Connection string

This .NET Framework Data Provider for OLE DB connection string can be used for connections to Oracle.

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;
Password
=myPassword;
OLEDB.NET=True;

Note! The keyword "OLEDB.NET" must be set to "True" for the OraOLEDB.Oracle provider to function with the .NET Framework Data Provider for OLE DB.