Oracle Database Connection

 

Odbc

New version:
Driver = {microsoft odbc for oracle}; server = oracleserver. world; uid = username; pwd = asdasd;

Old version:
Driver = {microsoft odbc driver for oracle}; connectstring = oracleserver. world; uid = myusername; pwd = mypassword;

Oledb, oledbconnection (. net)

Standard security:
Provider = msdaora; data source = myoracledb; user id = username; password = asdasd;
This ones from microsoft, the following are from oracle
Standard security:
Provider = oraoledb. oracle; data source = myoracledb; user id = username; password = asdasd;

Trusted connection:
Provider = oraoledb. oracle; data source = myoracledb; paiuthent = 1;

Oracleconnection (. net)

Standard:
Data source = oracle8i; integrated security = yes;
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 connectionstring;
Ooracleconn. open ();

Vb.net:
Imports system. data. oracleclient
Dim ooracleconn as oracleconnection = new oracleconnection ()
Ooracleconn. connectionstring = my connectionstring
Ooracleconn. open ()

Data shape

MS data shape:
Provider = msdatashape.1; persist security info = false; data provider = msdaora; data source = orac; user id = username; password = mypw

Example 1: namespace oracle
{
///

/// Summary of webform1.
///
Public class webform1: system. web. ui. page
{
Protected system. web. ui. webcontrols. datagrid datagrid1;
Private dataset mydataset = new dataset ();
Private void page_load (object sender, system. eventargs e)
{
// Place user code here to initialize the page
String connstring = provider = oraoledb. oracle; data source = jtest; user id = system; password = manager ;;
Oledbconnection conn = new oledbconnection (connstring );
String strcom = select * from system. lg_task_table;
Conn. open ();
Oledbdataadapter mycommand = new oledbdataadapter (strcom, conn );
Mycommand. fill (mydataset, system. lg_task_table );
Datagrid1.datasource = mydataset. tables [system. lg_task_table]. defaultview;
Datagrid1.databind ();
Conn. close ();

}