连接oracle数据库出现错误ORA-12541:TNS:no listener

Question

如何解决呢,我重新建个winform窗体就可以,求助

Answer 1

private void button1_Click(object sender, EventArgs e)
        {
            
            OracleConnection conn = new OracleConnection("Data Source=ORCL;User Id=system;Password=Lc19871124");
            try
            {
                conn.Open();
                OracleCommand cmd = conn.CreateCommand();                string sql = "insert into YANGFANGDATABASE(INVESTTIME,CREATETIME,INVESTBUSINESS," +
                                     "DATATYPE,CROPTYPE,DATALEVEL,INVESTADDRESS,PRODUCERS,PROCOMPANY,DETAIL) values" +
                                       "(to_date('2012-03-04','yyyy-mm-dd'),to_date('2012-05-06','yyyy-mm-dd'),'kkkllli','kdijfsdj','22fdf','diio','dlskao','iorjs','rororp','ldio')";
                cmd.CommandText = sql;
                int num = cmd.ExecuteNonQuery();
                if (num > 0)
                {
                    MessageBox.Show("添加成功");
                }
                else
                {
                    MessageBox.Show("添加失败");
                }
            }
            catch (Exception ee)
            {
                MessageBox.Show("错误" + ee.Message);
            }
            finally
            {
                conn.Close();
            }
        },这是代码,应该没错误,换个winform程序就可以运行