3 Replies Latest reply: Oct 7, 2013 9:54 AM by ReubenC RSS

    Connection with ASP DOTNET

    993069
      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
          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

            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

              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.