<div>
no, that connection string is for SQL Server.<br />
to start with; System.Data.SqlClient &nbsp;is not correct, you do have several choices.<br />
either some generic OleDb client or the Oracle client, both needs specific code, you cannot use the same code for sql server and oracle (unless you use the generic OleDb code
</div>


no, that connection string is for SQL Server.
to start with; System.Data.SqlClient  is not correct, you do have several choices.
either some generic OleDb client or the Oracle client, both needs specific code, you cannot use the same code for sql server and oracle (unless you use the generic OleDb code

<div>
Thank you for your comment. I was a SQL server person and now switch to Oracle. I use ODP.net. I tried to find the right setting in web.config for Oracle connection setting. I appreciate any one who can help me with issue.
</div>


Thank you for your comment. I was a SQL server person and now switch to Oracle. I use ODP.net. I tried to find the right setting in web.config for Oracle connection setting. I appreciate any one who can help me with issue.

<div>
<div class="content wysiwyg-content">
I started to initiate a .net web application with Oracle at the back end. My first time to connect Oracle. I have the following setting in the web.config file -<br />
<br />
&lt;configuration&gt;<br />
&nbsp; &lt;connectionStrings&gt;<br />
&nbsp; &nbsp; &lt;add name=&quot;AppServ&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;connectionString=&quot;data source=.\SQLEXPRESS;Integr<wbr />ated Security=SSPI;AttachDBFile<wbr />name=|Data<wbr />Directory|<wbr />\inetdb.md<wbr />f;User Instance=true&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;providerName=&quot;System.Data.<wbr />SqlClient&quot;<wbr /> /&gt;<br />
&nbsp; &lt;/connectionStrings&gt;<br />
<br />
&nbsp; &lt;appSettings&gt;<br />
&nbsp; &nbsp; &lt;add key=&quot;MyAppConn&quot; value=&quot;User Id=inepuser; Password=inepPwd; Data Source=lt10gr2; Enlist=false&quot;/&gt;<br />
&nbsp; &nbsp;&lt;/appSettings&gt;<br />
<br />
Is it right setting?
</div>
</div>


I started to initiate a .net web application with Oracle at the back end. My first time to connect Oracle. I have the following setting in the web.config file -

<configuration>
  <connectionStrings>
    <add name="AppServ"
         connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\inetdb.mdf;User Instance=true"
         providerName="System.Data.SqlClient" />
  </connectionStrings>

  <appSettings>
    <add key="MyAppConn" value="User Id=inepuser; Password=inepPwd; Data Source=lt10gr2; Enlist=false"/>
   </appSettings>

Is it right setting?

Oracle setting

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).