2

I would like to make an application that appends data to the oracle database table, but it does not work properly even if I do not establish the connection and I am getting this error

 String ConString = "DATA SOURCE=TEST;DBA PRIVILEGE=SYSDBA;PERSIST SECURITY INFO=True;USER ID=DERS;PASSWORD=1234";
        using (Oracle.ManagedDataAccess.Client.OracleConnection con = new Oracle.ManagedDataAccess.Client.OracleConnection(ConString))
        {
            OracleCommand cmd = new OracleCommand("INSERT INTO URUNLER VALUES('" + textBox1.Text.ToString() + "','" + textBox2.Text.Count() + "', '" + textBox3.Text + "','" + textBox4.Text + "')", con);
            OracleDataAdapter oda = new OracleDataAdapter(cmd);
            DataSet URUNLER = new DataSet();
            oda.Fill(URUNLER);

my app.config settings;

<dataSource alias="TEST" descriptor="TEST=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=192.168.1.27)(Port=1521)))(CONNECT_DATA=(SERVICE_NAME=test))) " />

and;

<settings>
<settings name="TNS_ADMIN" value="C:\Program Files (x86)\Oracle Developer Tools for VS2013\network\admin" />
</settings>


<connectionStrings>
<add name="TEST" connectionString="User Id=DERS;Password=1234;Data Source=TEST" providerName="Oracle.ManagedDataAccess.Client" />
<add name="WindowsFormsApplication5.Properties.Settings.ConnectionString" connectionString="DATA SOURCE=TEST;DBA PRIVILEGE=SYSDBA;PASSWORD=1234;PERSIST SECURITY INFO=True;USER ID=DERS" providerName="Oracle.ManagedDataAccess.Client" />
<clear />

finally my tnsnames.ora file;

TEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.27)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = test)
    )
  )
yusuf simsek
  • 21
  • 1
  • 3

0 Answers0