Link to home
Start Free TrialLog in
Avatar of Sachin Kakirde
Sachin KakirdeFlag for India

asked on

how to user oracle client is asp.net c# in 2015

We are getting error while connecting Oracle 19c Database in .Net 2015. 
Avatar of Alex [***Alex140181***]
Alex [***Alex140181***]
Flag of Germany image

We need much more detailed information!
What error? How do you connect (method, connection string...)?
Avatar of Arana (G.P.)
Arana (G.P.)

Are you u sing instant client? unmanaged or managed driver?
Avatar of Sachin Kakirde

ASKER

Currently we are using Oracle 11g and .NET 2010. In the said environment we are using connection string to connect database and we used reference System.Data.OracleClient;

Now we are change to Oracle 19c and .NET 2015. We migrated database to 19c and upgraded project to 2015.
We are using Oracle 19c client and managed driver

We are using  
public GetCon()
{
            connection = new OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ProjectMgmt"].ConnectionString);
            connection.Open();        
}
We are getting message "Unable to open database connection".

Need solution on the same. 
Can you post the ProjectMgmt setup from your App.config?
Yes, we need that info as slightwv suggested, but my feeling tells me, that we might end up seeing a connection string that worked in 11 but due to CDB/PDB stuff, this setup won't work anymore ;-)
(connection string with SID, but with 19, you'll end up rather in the CDB than the PDB... we had some serious issues with stuff like that when we migrated back then)
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.