Oracle Strings

ODBC

New version:

"Driver={Microsoft ODBC for Oracle};
Server=OracleServer.world;
Uid=myUsername;
Pwd=myPassword;"

Old version:

"Driver={Microsoft ODBC Driver for Oracle};
ConnectString=OracleServer.world;
Uid=myUsername;
Pwd=myPassword;"

OLE DB, OleDbConnection (.NET)

Standard security:

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

This one is from Microsoft, the following
are 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;"

OracleConnection (.NET)

Standard:

"Data Source=MyOracleDB;
Integrated Security=yes;"

Note: This one works only with Oracle 8i
release 3 or later

Specifying username and password:

"Data Source=MyOracleDB;
User Id=myUsername;
Password=passwd;
Integrated Security=no;"

Note: This one works only with Oracle 8i
release 3 or later

Declare the OracleConnection:

C#:

using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "my connection string";
oOracleConn.Open();

VB.NET:

Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "my connection string"
oOracleConn.Open()

Core Labs OraDirect (.NET)

Standard:
"User ID=scott;
Password=tiger;
Host=ora;
Pooling=true;
Min Pool Size=0;
Max Pool Size=100;
Connection Lifetime=0"

Data Shape

MS Data Shape:
"Provider=MSDataShape.1;
Persist Security Info=False;
Data Provider=MSDAORA;
Data Source=orac;
user id=myUsername;
password=myPassword"