//Here is the connection function using Oracle.DataAccess.Client;
        public static OracleConnection
               GetDBConnection(string host="160.60.3.60", int port=1521, String sid="orcl", String user="user55", String password="user55")
        {

         MessageBox.Show("Getting Connection ...");

            // Connection string to connect directly to Oracle.
            string connString = "Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = "
                 + host + ")(PORT = " + port + "))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = "
                 + sid + ")));Password=" + password + ";User ID=" + user;


            OracleConnection conn = new OracleConnection(connString);


            conn.ConnectionString = connString;

            return conn;
        }