Reader Level:
ARTICLE
  • 0
  • 0
  • 93164

Description of the Article

A Simple program to show connecting to an 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 OLEDB 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);
}
}
}

Article Extensions
Contents added by loga nathan on Jun 01, 2012
lullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullai
Ravi Shankar

Ravi Shankar (not the musician) has been programming in C, C++ and Visual Basic for over 8 years and has a lot of experience in Object Modelling and Database Design and Management. Ravi is now working...

  • 569rank
  • 93K readers
COMMENT USING

Trending up