Oracle Connection String :OLE DB, OleDbConnection (.NET)

You can use both provider Microsoft or oracle

Provider from Microsoft.

Standard security
Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;

Trusted connection
Provider=msdaora;Data Source=MyOracleDB;Persist Security Info=False;Integrated Security=Yes;

Or

Provider from Oracle.

Standard Security
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;

Trusted Connection
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;