Click to View Source Code
// ODBC DSN |
using System.Data.Odbc;
OdbcConnection conn = new
OdbcConnection();
conn.ConnectionString =
"Dsn= color="red">DsnName;" +
"Uid= color="red">UserName;" +
"Pwd= color="red">Secret;";
conn.Open();
|
Click to View Source Code
// ODBC -- New Microsoft Driver
|
using System.Data.Odbc;
OdbcConnection conn = new
OdbcConnection();
conn.ConnectionString =
"Driver={Microsoft ODBC for Oracle};" +
"Server= color="red">OracleServer.world;" +
"Uid= color="red">UserName;" +
"Pwd= color="red">Secret;";
conn.Open();
|
Click to View Source Code
// ODBC -- Old Microsoft Driver
|
using System.Data.Odbc;
OdbcConnection conn = new
OdbcConnection();
conn.ConnectionString =
"Driver={Microsoft ODBC Driver for Oracle};" +
"ConnectString= color="red">OracleServer.world;" +
"Uid= color="red">UserName;" +
"Pwd= color="red">Secret;";
conn.Open();
|
Click to View Source Code
// ODBC -- Oracle Driver
|
using System.Data.Odbc;
OdbcConnection conn = new
OdbcConnection();
conn.ConnectionString =
"Driver={Oracle ODBC Driver};" +
"Dbq= color="red">myDataBase;" +
// define in tsnames.ora
"Uid= color="red">UserName;" +
"Pwd= color="red">Secret;";
conn.Open();
|
Click to View Source Code
// OleDb -- Microsoft Driver
|
using System.Data.OleDb;
OleDbConnection conn = new
OleDbConnection();
conn.ConnectionString =
"Driver=MSDAORA;" +
"Data Source= color="red">ServerName;" +
"User id= color="red">UserName;" +
"Password= color="red">Secret;";
conn.Open();
|
Click to View Source Code
// OleDb -- Oracle Driver -- Standard
Connection |
using System.Data.OleDb;
OleDbConnection conn = new
OleDbConnection();
conn.ConnectionString =
"Driver=OraOLEDB.Oracle;" +
"Data Source= color="red">ServerName;" +
"User id= color="red">UserName;" +
"Password= color="red">Secret;";
conn.Open();
|
Click to View Source Code
// OleDb -- Oracle Driver -- Trusted
Connection |
using System.Data.OleDb;
OleDbConnection conn = new
OleDbConnection();
conn.ConnectionString =
"Driver=OraOLEDB.Oracle;" +
"Data Source= color="red">ServerName;" +
"OSAuthent=1;";
conn.Open();
// or
using System.Data.OleDb;
OleDbConnection conn = new
OleDbConnection();
conn.ConnectionString =
"Driver=OraOLEDB.Oracle;" +
"Data Source= color="red">ServerName;" +
"User id=/" +
"Password=;";
conn.Open();
|
Click to View Source Code
// .NET DataProvider from Microsoft
// -- Standard Connection
|
using System.Data.OracleClient;
OracleConnection conn = new
OracleConnection();
conn.ConnectionString =
"Data Source= color="red">ServerName;" +
"User id= color="red">UserName;";
"Password= color="red">Secret;";
conn.Open();
|
Click to View Source Code
// .NET DataProvider from Microsoft
// -- Trusted Connection
|
using System.Data.OracleClient;
OracleConnection conn = new
OracleConnection();
conn.ConnectionString =
"Data Source= color="red">Servername;" +
"Integrated Security=Yes;";
conn.Open();
|
Click to View Source Code
// .NET DataProvider from Oracle
// -- Standard Connection
|
using Oracle.DataAccess.Client;
OracleConnection conn = new
OracleConnection();
conn.ConnectionString =
"Data Source= color="red">ServerName;" +
"User id= color="red">UserName;";
"Password= color="red">Secret;";
conn.Open();
|
Click to View Source Code
// .NET DataProvider from Oracle
// -- Trusted Connection
|
using Oracle.DataAccess.Client;
OracleConnection conn = new
OracleConnection();
conn.ConnectionString =
"Data Source= color="red">Servername;" +
"Integrated Security=Yes;";
conn.Open();
|
|