This discussion is archived
3 Replies Latest reply: Oct 7, 2013 7:54 AM by ReubenC RSS

Connection with ASP DOTNET

993069 Newbie
Currently Being Moderated
Hi,

I am not able to stablish SQL Developer connection with ASP.NET, can anyone please help me and let me know the steps how can I do this?

Thanks,
Abhi
  • 1. Re: Connection with ASP DOTNET
    185706 Newbie
    Currently Being Moderated
    In the web.config add this

    <connectionStrings>
              <add name="ORAConnectionString" connectionString="Data Source=10.XXX.XXX.XXX:1521/SOE;User ID=XXXX;Password=XXXX;" providerName="System.Data.OracleClient"/>
    </connectionStrings>

    This assumes that you have the client installed -- it also allows you to connect with using the TNSNAMES
  • 2. Re: Connection with ASP DOTNET
    b558ceb4-75c3-4c36-9703-45433423d4a9 Newbie
    Currently Being Moderated

    can u pls tell me, what is your means by client installed ?

    i have my oracle 11 g installed on server

    and we have only access  to that by browser and nothing else,

    i want to connect to it with asp dot net application, then what should i do?

  • 3. Re: Connection with ASP DOTNET
    ReubenC Explorer
    Currently Being Moderated

    185706 wrote:

     

    In the web.config add this

    <connectionStrings>
              <add name="ORAConnectionString" connectionString="Data Source=10.XXX.XXX.XXX:1521/SOE;User ID=XXXX;Password=XXXX;" providerName="System.Data.OracleClient"/>
    </connectionStrings>

    This assumes that you have the client installed -- it also allows you to connect with using the TNSNAMES

    I wouldn't suggest using system.data.oracleclient.  That was deprecated awhile ago.

    You should use one of the .Net providers from Oracle instead.

Legend

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