You must Sign In to post a response.
  • Category: General

    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
    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
    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
    "Failure is the path of least persistence"

  • #761355
    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
    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
    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.


Sign In to post your comments