This discussion is archived
1 Reply Latest reply: Nov 4, 2012 11:31 PM by 896548 RSS

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

955649 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points