Friday, February 19, 2016

The underlying provider failed to open error in C#

 

This is one of the very common error we use to get while using Oracle database. The error “The underlying provider failed to open” is bit confusing if you are not able to view the inner exception.

Once you get the exception, just expand the exception try to read the inner exception. Whihc will be more clear than this.

I just exapanded the exception and the actual error we get is “ORA – 12154: TNS:could not resolve the conect identifier… ” If you read this exception it will be more clear and you might know what needs to be done.

Below is the screen print of the error.

image

I assume you have installed Oracle client in your machine. This error just because you missed the 3 required files

1. tnsnames.ora

2. sqlnet.ora

3. ldap.ora

So in order to resolve the error “ORA – 12154: TNS:could not resolve the conect identifier…” you have to copy three files to the oracle installation location.

Oracle installation folder may vary depends on where you have installed the software and the windows version.

I have given you two possible location normally oracle get installed.

C:\app\client\<Userid>\product\12.1.0\client_1\network\admin

or

C:\Oracle\product\12.1.0\client_1\Network\Admin

If you cannot find Network and Admin folder in Client_1 path you may create those two folders.

Now you try to run the code and see if the issue gets resolved or not.

I hope it helps you to resolve the issue.

Thanks you for visintg my blog.

29 comments:

Unknown said...

These provided information was really so nice,thanks for giving that post and the more skills to develop after refer that post.our giving articles really impressed for me,because of all information so nice.


Best Java J2ee training institutes in chennai

Unknown said...

nice...
Cloud-Computing training in chennai

Jones said...

Learn Dot Net Training in Chennai at Credo Systemz. Training offered by MNC Experts. Rated as Best .Net Training Institute in Chennai. Learn C# & ASP.Net Course with 100% Placement.

.NET Framework developed by Microsoft is an integral part for most of the primary applications running on Windows. .NET with its consistent and comprehensive programming model, created a technological revolution in recent years. Applications built using .NET has the capability to entice the user with visually stunning experiences along with faultless and secured communication system.

Akshaysri said...

Very nice post here and thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable information's.
New Zealand Education Consultants in Chennai

Unknown said...

Great information . I find site blogs with lots of useful information

Red Hat Linux Training in Chennai

Unknown said...

Really a good technical site,keep on writing good stuffs
dot net training in chennai

Karthika Shree said...

I just see the post i am so happy to the communication science post of information's.So I have really enjoyed and reading your blogs for these posts.Any way I’ll be replay for your great thinks and I hope you post again soon...
AWS Training in Chennai

Unknown said...

I am definitely enjoying your website. You definitely have some great insight and great stories. 
python training in annanagar | python training in chennai

python training in marathahalli | python training in btm layout

python training in rajaji nagar | python training in jayanagar

simbu said...

Thank you for benefiting from time to focus on this kind of, I feel firmly about it and also really like comprehending far more with this particular subject matter. In case doable, when you get know-how, is it possible to thoughts modernizing your site together with far more details? It’s extremely useful to me.

java training in chennai | java training in bangalore

java online training | java training in pune

java training in chennai | java training in bangalore

java training in tambaram | java training in velachery

Unknown said...

This is quite an educational arrange. It has famous breeding about what I rarity to vouch. Colossal proverb. This trumpet is a famous tone to nab to troths. Congratulations on a career well achieved. This arrange is synchronous s informative impolite festivity to pity. I appreciated what you ok extremely here.
Python training in marathahalli
Python training in pune
AWS Training in chennai

gowsalya said...

Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.
Devops Training in Chennai
Devops training in sholinganallur

sunshineprofe said...

Thank you so much for sharing this worth able content with us. The concept taken here will be useful for my future programs and I will surely implement them in my study. Keep blogging article like this.
safety course in chennai

Manipriyan said...
This comment has been removed by the author.
Mithun said...

Great Post with lots of useful informations. Excellent blog very much interesting...
SAP Training in Chennai | AWS Training in Chennai | SAP Training | AWS Training

Manigandan said...

Awesome blog with lots of useful stuffs on AWS. Useful blog..
Hardware and Networking Training in Chennai
CCNA Training in Chennai
AWS Training in Chennai
SAP Training in Chennai
Software Testing Training in Chennai
Java Training in Chennai
QTP Training in Chennai
iOS Training in Chennai
Oracle Training in Chennai
Pearson Vue Exam Center in Chennai

Anonymous said...


Thanks for sharing such a great information.It is really one of the finest article and more informative too. I want to share some informative data about .net training online and c# online training . Expecting more articles from you.

Jack sparrow said...



Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing.. I also want to share about mainframe course and mainframe db2 tutorial.thank you.


Mithun said...

Wonderful Blogspot
AWS Training in Chennai
AWS Training Institutes in Chennai
AWS Training Center in Chennai
AWS Training Course in Chennai
AWS Training Class in Chennai
Best AWS Training in Chennai
AWS Training Institute in Chennai
AWS Certification in Chennai
AWS Classes in Chennai
AWS Training

devi said...


Awesome article! It is in detail and well formatted that i enjoyed reading. which inturn helped me to get new information from your blog. After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article.
Data Science Training In Chennai

Data Science Online Training In Chennai

Data Science Training In Bangalore

Data Science Training In Hyderabad

Data Science Training In Coimbatore

Data Science Training

Data Science Online Training

svrtechnologies said...



That is nice article from you , this is informative stuff . Hope more articles from you . I also want to share some information about mainframe training in hyderabad .

Ranjith said...

Thanks for sharing an informative blog keep rocking bring more details.I like the helpful info you provide in your articles. I’ll bookmark your weblog and check again here regularly. I am quite sure I will learn much new stuff right here! Good luck for the next!

python Training in chennai

python Course in chennai

360digiTMG Training said...

Thanks for the nice blog. It was very useful for me. I'm happy I found this blog. Thank you for sharing with us,I too always learn something new from your post.
Best Data Science Courses in Hyderabad

Rajendra Cholan said...

Data Science Course in Chennai | Infycle Technologies

Data science can be defined as a blend of Mathematics. The entire Data Life Cycle is covered in our Data Science course in Chennai, which includes Data Architecture, Statistics, Advanced Data Analytics, and Machine Learning. To enrol in this course, you must have a basic understanding of statistics and mathematics. We Infycle offer the Data Science course in Chennai with 200% practical classes, pre-mock interview sessions, and more career counseling classes. For a free demo session, call us at 7502633633.
Best course in Chennai

Rajendra Cholan said...

Description:
Study Hadoop for making your career as a shining sun with Infycle Technologies. Infycle Technologies offers the best Hadoop Training in Chennai, providing complete hands-on practical training of professional specialists in the field. In addition to that, it also offers numerous programming language tutors in the software industry such as Oracle, Python, Big Dat, Hadoop, etc. Once after the training, interviews will be arranged for the candidates, so that, they can set their career without any struggle. Of all that, 100% placement assurance will be given here. To have the top career in IT industry, dial 7502633633 to Infycle Technologies and grab a free demo to know more.
Best software training in chennai

traininginstitute said...

Thanks for the informative and helpful post, obviously in your blog everything is good..
data scientist training in malaysia

Deekshitha said...

Informative blog
cyber security training in ahmedabad

360DigiTMG said...

It's late finding this act. At least, it's a thing to be familiar with that such events exist. I agree with your Blog and I will be back to inspect it more in the future so please keep up your act.
data analytics course in hyderabad

360DigiTMG said...

Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained!
data analytics courses in hyderabad

Nila dharshan said...

Great blog, keep sharing with us.

Qlik Sense Training in Chennai
Qlik Sense Online Training