none
Not able to connect to Oracle 12c database using ASP.Net RRS feed

  • Question

  • Hi,

    I have an ASP.Net web application where i am trying to perform CRUD operations in my database (Oracle 12c 64-bit). I am using the below connection string in web.config to connect to my database.

    <add name="CS" connectionString="Provider=ORAOLEDB.ORACLE;User ID=xxxxx;password=xxxxx;Data Source=xxxxx;" />

    When executing the application and trying to connect to the database, I am getting the exception "The ORAOLEDB.ORACLE is not registered on the local machine". 

    Please note that this error was not there when i had my database as Oracle 11g. This came up only after i installed 12c. Please let me know if anything else is required for connecting to 12c. Thanks in advance!!!

    Regards,

    Ashfaque

    Saturday, June 10, 2017 10:12 AM

All replies

  • Consider asking here https://forums.asp.net/

    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    Saturday, June 10, 2017 11:06 AM
  • You should post to an Oracle fourm, since you don't have a c# issue.
    Saturday, June 10, 2017 11:39 AM
  • I don't know if it will help, but I wrote a blog post last month about what we did to solve Oracle connection problems:

    http://geek-goddess-bonnie.blogspot.com/2017/05/accessing-oracle-databases-in-net.html


    ~~Bonnie DeWitt [C# MVP]

    http://geek-goddess-bonnie.blogspot.com

    Saturday, June 10, 2017 4:40 PM
  • Hi  Ashfaque Anwar,

    For your question, it seems that you don't install the Oracle 12c database correctly. You could download the Oracle Data Access Components and install it to solve the issue. The components can be downloaded from:

    http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html.

    Maybe you could try this.

    https://social.msdn.microsoft.com/Forums/en-US/1cd543ac-930e-4c32-b1ba-8a4f2beb9999

    To get more professional support, you need to go to oracle forum or ASP.NET forum.

    Best Regards,

    Wendy



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, June 12, 2017 6:22 AM
  • This is really an ASP.NET question and should be asked in the ASP.NET forums.

    But I suspect the problem is that you installed the wrong version of ODP.NET. Your app pool is probably configured to run as x64 out of the box. Therefore you have to install the x64 version of the Oracle client. If your app pool is running x86 then you need to install the x86 version of the client. In my experience having both clients on the same machine at the same time tends to cause problems so you should pick a bitness and stick with it. 

    You can verify whether you have the right client installed by using the ODBC Admin tool (x86 or x64) and see if the Oracle driver appears.

    Please post further questions related to Oracle in the Oracle forums. The version of Oracle that shipped with the framework has been deprecated for years and should not be used. We do not provide support for non-MS products in these forums.

    Michael Taylor
    http://www.michaeltaylorp3.net

    Monday, June 12, 2017 1:43 PM