Connection string to connect to oracle database using [Resolved]

Posted by Amulya under ASP.NET on 8/31/2013 | Points: 10 | Views : 1727 | Status : [Member] | Replies : 1
Connection string to connect to oracle database using


Posted by: Satyapriyanayak on: 8/31/2013 [Member] [MVP] Silver | Points: 50


Add reference of Oracle database client library.

Right click on “Add Reference” inside your project.
From Add Reference dialog box click on “.Net” tab
Select “System.Data.OracleClient” from Component Name
Click “OK” button to add reference.

In web.config file

<add name="ConnectionString" connectionString="Data Source=XE;User ID=system;Password=xyz;Persist Security Info=True;Connection Lifetime=10" providerName="System.Data.OracleClient"></add>

call it in webpage

string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

Also refer

If this post helps you mark it as answer

Amulya, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response