Hi everyone…
you can connect to oracle database either by OleDb object or by DSN. Following code snippet did the trick. Go through it.
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);
}
}
}
Courtesy Ravi Shankar
—
Keep Smiling 🙂
May 28, 2008 at 8:31 am
[…] passen. Kann es sein, dass du den DSN-Wert falsch eingetragen hast bzw. den falschen Wert nimmst? Hier kannst du dir auch noch ein Code-Snippet zu dem Thema ansehen. Vielleicht hilft dir das weiter. […]
October 21, 2008 at 11:31 am
eeegtre’rtty’yyiyuo’
March 12, 2009 at 4:47 am
hi wat are all the requirements i mean installations to connect to oracle database ?
June 25, 2011 at 2:14 pm
[…] 4)Connect to ORACLE database using C# […]