private void button1_Click(object sender, EventArgs e)
        {
            string sConn = "";

            sConn += "Data Source =                                                         ";
            sConn += "  (DESCRIPTION =                                                      ";
            sConn += "    (ADDRESS_LIST =                                                   ";
            sConn += "      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521)) ";
            sConn += "    )                                                                 ";
            sConn += "    (CONNECT_DATA =                                                   ";
            sConn += "      (SERVICE_NAME = AMES)                                           ";
            sConn += "    )                                                                 ";
            sConn += "  );User Id=mesmgr;Password=mesmgr;                                   ";

            string SQL = "SELECT SYSDATE FROM DUAL";

            OracleConnection conn = null;
            try
            {
                conn = new OracleConnection(sConn);
                conn.Open();
                OracleCommand comm = new OracleCommand(SQL, conn);
                comm.CommandType = CommandType.Text;

                OracleDataReader rs = comm.ExecuteReader();
                               
                while (rs.Read())
                {
                    MessageBox.Show("성공 : " + rs[0].ToString());
                }
                rs.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("실패 : " + ex.Message);
            }
            finally
            {
                conn.Close();
            }


        }


WRITTEN BY
테네시왈츠
항상 겸손하게 항상 새롭게 항상 진실하게

,