2 Replies Latest reply on Sep 14, 2012 7:56 PM by Charlie (ME)

    Using LDAP (OID) in place of TNSNAMES in .Net web.config file

    Charlie (ME)
      We have an application that stores the TNS entry in the web.config like so:
      <connectionStrings>
          <add name="REPORTS" connectionString="Data Source=(DESCRIPTION=
                  (ADDRESS=
                      (PROTOCOL=TCP)
                      (HOST=<some_server1.domain>)
                      (PORT=1521))
                  (ADDRESS=
                      (PROTOCOL=TCP)
                      (HOST=<some_server2.domain>)
                      (PORT=1521))
                  (LOAD_BALANCE=yes)
                  (CONNECT_DATA=
                      (SERVER=DEDICATED)
                      (SERVICE_NAME=<SID>)
                      (FAILOVER_MODE=(TYPE=SELECT)
                      (METHOD=BASIC)
                      (RETRIES=180)
                      (DELAY=5))));
                  User Id=<user_name>;
                  Password=<password>;
                  Pooling=true;
                  Connection Lifetime=0;
                  Max Pool Size=300;
                  Min Pool Size=1;"
                  providerName="Oracle.DataAccess.Client Version 11.2.0.1.2"/>
      </connectionStrings>
      Is it possible to change just the web.config file so that we can connect using LDAP/OID without having to make coding changes the the application itself?