Category: General

06 Aug 2015 23:08

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	3

How to Fix Oracle Provider issue in Dotnet

Hi experts,

I am struggling to configure Oracle Provider issue. I tried lot of things but none of these worked for me.

I have installed Oracle 10g Successfully. Now, I need Oracle Provider - UDP

What should I install so I can connect Oracle database connecting using C#.

I researched and observed that I need Oracle .net Provider 32 bit and 64 bit for windows 7 from Visual Studio 2012 only.

I did search on web but no luck to find any related solution.

#761348

06 Aug 2015 23:10

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	1

I have attached issues snapshots any one solve this

Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com

'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

Delete Attachment

#761351

06 Aug 2015 23:49

Joined:	06/04/2012
Level:	Gold
Points:	4230

Points:	3

Hello Kumar,

I don't know the exact solution for that error you are facing it from long time. But i can suggest you to go through the below links. It will help you.

http://www.oracle.com/technetwork/articles/cook-vs08-088541.html

https://msdn.microsoft.com/en-us/library/aa984313(v=vs.71).aspx

Hope it will work for you.

Regards,
Nirav Lalan
DNS Gold Member
"If you can dream it, you can do it."

#761355

07 Aug 2015 01:23

Joined:	08/07/2010
Level:	Gold
Points:	6482

Points:	3

You need Oracle Data Access Client to be able to connect to oracle database from the dotnet application. You need to install ODAC client components on your application server. Even in our projects we are using ODAC to connect to oracle database from our vb.net application. Then you have to add reference to the Oracle.DataAccess.dll file in your project to be able to connect to the database and perform database related operations.

Miss. Jain
Microsoft Certified Technology Specialist in .Net

#761359

07 Aug 2015 01:41

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	1

Hi
Jain

I refer also this
using Oracle.DataAccess.Client;
using Oracle.ManagedDataAccess.Client;

But I meet same Issue this

{"ORA-12154: TNS:could not resolve the connect identifier specified"}

I have attached Issues snapshots given below

Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com

'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

Delete Attachment

#761360

07 Aug 2015 01:53

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	1

Hi
Jain

Can you share with just Connect the Oracle DB Code

My Code this not Working

Namespace this


using Oracle.DataAccess.Client;
using Oracle.ManagedDataAccess.Client;
using Oracle.DataAccess;

then Button Click code this


con = new Oracle.DataAccess.Client.OracleConnection();
            con.ConnectionString = "Data Source=local/orcl;User Id=Dbname;Password=DBPWD;";
            con.Open();
            Console.WriteLine("Connected to Oracle" + con.ServerVersion);

Can you assist for this

Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com

'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

How to Fix Oracle Provider issue in Dotnet

About dotnetspider.com

Quick Links

General

Services