oracleÁ¬½Ó×Ö·û´®ÎÊÌ⣿

  OracleConnection oledbCon = new OracleConnection("Data Source = zghouseDB; User Id = scott; Password = oracle; Integrated Security = no;");
            if (oledbCon.State == ConnectionState.Closed)
            {
                oledbCon.Open();
                if (oledbCon == null)
                {
                    MessageBox.Show("odbcÊý¾Ý¿âÁ¬½Óʧ°Ü", "ϵͳÌáʾ");
                }
            }
            return oledbCon;

ÔÚÖ´ÐÐoledbCon.Open();Õâ¾äµÄʱºò±¨´í£¬ÀàÐÍΪ£ºORA-12154: TNS: ÎÞ·¨½âÎöÖ¸¶¨µÄÁ¬½Ó±êʶ·û
Çë°ï°ï棡

---

ORA-12154  ÕâÊǸö±È½Ï³£¼ûµÄ´íÎó¡£Äã´ò¿ª¼àÌý·þÎñ¿´¿´

---

# listener.ora Network Configuration File: F:\oracle\product\10.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:\oracle\product\10.1.0\db_1)
      (PROGRAM = extproc)
    ) <