Connect Oracle using ODBC

1. Go to control panel and Create a ODBC provider




2. Create a C# console project and insert the code below

<br />using System;<br />using System.Collections.Generic;<br />using System.Linq;<br />using System.Text;<br />using System.Data.Odbc;<br /><br />namespace testOracle<br />{<br /> class Program<br /> {<br /> static void Main(string[] args)<br /> {<br /> OdbcConnection myConnection = new OdbcConnection();<br /> myConnection.ConnectionString = "Driver={Microsoft ODBC for Oracle};Server=sltest;Uid=scott;Pwd=tiger";<br /> myConnection.Open();<br /> string cmdtxt = null;<br /> OdbcCommand myCommand = new OdbcCommand();<br /><br /> myCommand.Connection = myConnection;<br /> OdbcDataAdapter myAdapter = new OdbcDataAdapter();<br /> cmdtxt = "SELECT * FROM Dept";<br /><br /> Console.WriteLine(cmdtxt);<br /> myCommand.CommandText = cmdtxt;<br /><br /> myAdapter.SelectCommand = myCommand;<br /> OdbcDataReader moddata = default(OdbcDataReader);<br /> moddata = myCommand.ExecuteReader();<br /><br /> while (moddata.Read() == true)<br /> {<br /> try<br /> {<br /> Console.WriteLine(moddata[1]);<br /> }<br /> catch (Exception ex)<br /> {<br /> Console.WriteLine(ex.Message);<br /> }<br /> }<br /> moddata.Close();<br /> myConnection.Close();<br /> }<br /> }<br />}<br />