1 Reply Latest reply: Nov 5, 2012 1:31 AM by 896548 RSS

    how to fetch host database in system to run web application?

    955649
      Hi all,

      i am having database in server and i have to run my web application in client machine. how to set the connection of server database in web.config file.

      thanks
        • 1. Re: how to fetch host database in system to run web application?
          896548
          I hope that you installed oracle client and configured tnsnames file in oracle client on client machine.
          Below is script to web.config
            <connectionStrings>
                  <add name="OracleConnectionString" connectionString="DATA SOURCE=hostname/orcl;PASSWORD=yr password;PERSIST SECURITY INFO=True;USER ID=yrusername/schemaname"
                      providerName="Oracle.DataAccess.Client" />
              </connectionStrings>
          Rgds