DotNet Programming

// Data Provider for OLE DB
using System.Data.OleDb

OleDbConnection oracleConn = new OleDbConnection("Provider= \"OraOLEDB.Oracle.1\";User ID=scott;Password=tiger;Data Source=yourSource; Extended Properties="";Persist Security Info=False";);

//Data Provider for ODBC
using System.Data.Odbc

OdbcConnection oracleConn = new OdbcConnection("DSN=odbcName ;UID=scott;PWD=tiger;DRIVER={Microsoft ODBC for Oracle};
SERVER=oracleServerNameOr IPAddress;";);

//Data Provider for Oracle Client
using System.Data.OracleClient

OracleConnection oracleConn = new OracleConnection("user id=scott;
data source=oracleSN;password=tiger";);