Error while connecting to Oracle database

5 posts, 0 answers
  1. Amit
    Amit avatar
    11 posts
    Member since:
    Feb 2013

    Posted 10 Apr 2013 Link to this post

    Hi,

    I am trying to connect to Oracle database using Test studio to verify values are being persisted properly. I tried writing code using Oracle client but I am getting following error:

    'System.Data.OracleClient.OracleConnection' is obsolete: 'OracleConnection has been deprecated. http://go.microsoft.com/fwlink/?LinkID=144260'

    Also, tried with OleDB connection, but getting OleDB.Oracle not registered on local machine error. Please let me know if any solution is available for the same.


    Thanks,
    Amit

  2. Amit
    Amit avatar
    11 posts
    Member since:
    Feb 2013

    Posted 11 Apr 2013 Link to this post

    It's been a day and no response. Please let me know if there is any possibility to connect to oracle db to retrieve value.

    Oracle Client has been deprecated and now suggested to use Oracle.DataAcccess which can't be configured in Test studio.
  3. Ivaylo
    Admin
    Ivaylo avatar
    782 posts

    Posted 11 Apr 2013 Link to this post

    Hello Amit,

    I am sorry you are experiencing this issue.

    In order to overcome this error, click on the "View Class" button(see the example screenshot provided) and add the following attribute right above the coded step you are using:

    [ObsoleteAttribute("OracleConnection has been deprecated. http://go.microsoft.com/fwlink/?LinkID=144260", false)]


    See this article for more information.

    Kind regards,
    Ivaylo
    the Telerik team
    Quickly become an expert in Test Studio, check out our new training sessions!
    Test Studio Trainings
  4. Amit
    Amit avatar
    11 posts
    Member since:
    Feb 2013

    Posted 12 Apr 2013 Link to this post

    Thanks Ivaylo. 

    I added this but now getting following error:
    System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)

    I have downloaded 64 bit Oracle Instant client (instantclient_11_2) and added location in PATH but still same error. Please let me know if I am missing something.
  5. Ivaylo
    Admin
    Ivaylo avatar
    782 posts

    Posted 12 Apr 2013 Link to this post

    Hello Amit,

    I am sorry you are still experiencing this issue. This is the workaround we have been providing to customers which seems to be working until now. We will need to investigate this further. Regarding the OleDB.Oracle not registered on local machine error could you please check this article and see if you will be able to workaround it.

    Kind regards,
    Ivaylo
    the Telerik team
    Quickly become an expert in Test Studio, check out our new training sessions!
    Test Studio Trainings
Back to Top