Oracle Strings
 

Check Out  http://www.dotnetUncle.com

Home

SQL 2000 Strings

SQL 2005 Strings

MS Access Strings

MySQL Strings

Oracle Strings

Notes on .NET

 

 

 

 

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"