3 Replies Latest reply: Jan 2, 2013 7:35 PM by 615576 RSS

    How to connect to a balanced database

    982514
      Hello,

      I have never connected to a oracle database before. Im using c# (framework 4.0), and I also have some questions:

      1) Do I need to install some oracle software in my machine (the database is in another computer, in the network) or just use some .dll?

      2) The connection string that I have is that one above, can anyone says if that is correct?

      connection string:


      Data Source=
      +(DESCRIPTION =+
      +(ADDRESS = (PROTOCOL = TCP)(HOST =********)(PORT = 1521))+
      +(ADDRESS = (PROTOCOL = TCP)(HOST =********)(PORT = 1521))+
      +(LOAD_BALANCE = yes)+
      +(CONNECT_DATA =+
      +(SERVER = DEDICATED)+
      +(SERVICE_NAME = SECAD)+
      +)+
      +)+

      SECADOFITE1 =
      +(DESCRIPTION =+
      +(ADDRESS_LIST =+
      +(ADDRESS =+
      +(PROTOCOL = TCP)+
      +(Host = ********)+
      +(Port = 1521)+
      +)+
      +)+
      +(CONNECT_DATA = (SID = SECAD1)+
      +)+
      +)+

      SECADOFITE2 =
      +(DESCRIPTION =+
      +(ADDRESS_LIST =+
      +(ADDRESS =+
      +(PROTOCOL = TCP)+
      +(Host = ********)+
      +(Port = 1521)+
      +)+
      +)+
      +(CONNECT_DATA = (SID = SECAD2)+
      +)+
      +);+
      User Id=********;
      Password=********;