Connect to Oracle DataBase

Oracle Connect to Oracle Database submitted by User Level Date of submissionRavi shankarbeginner05/03/2001
Description of the Article
A simple program to show connecting to A Oracle database.
Source Code:

/***********************************************************************/
Program Name:ado Connection to Oracle
DESCRIPTION:A Sample program to connect to the Oracle database
Created on:01 May 2001
Created By:ravi Shankar Venkatarajalu
/***********************************************************************/
Using System;
Using System.Data;
Using System.Data.ADO;

Class Oracletest
{
static void Main ()
{


Uid-user Id
Pwd-password
Server-your Service Name
Using Microsoft ODBC for Oracle dsn-less
Const string strconn = "Provider=msdasql;driver={microsoft
ODBC for ORACLE}; Uid=scott; Pwd=tiger; Server=fnqa ";

Using Microsoft OLE DB Provider for Oracle
Const string strconn = "Provider=msdaora.1;data
source=oracle_db; User Id=scott; Password=tiger ";

Using DSN Connection
Const string strconn =
"DSN=ORACLE_DSN; Uid=scott; Pwd=tiger ";
Const string strSQL = "SELECT * from EMP";

Try
{
DataSet ds = new DataSet ("Employeesset");
Adodatasetcommand mycommand = new
Adodatasetcommand (Strsql,strconn);
Mycommand.filldataset (ds, "Buyer");
Console.WriteLine (ds. XML);
}
catch (Adoexception e)
{
Console.WriteLine ("Exception occured:
{0} ', E.errors[0]. message);
}


}
}