This is a migrated thread and some comments may be shown as answers.

Error while connecting to Oracle database

4 Answers 615 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Amit
Top achievements
Rank 1
Amit asked on 10 Apr 2013, 08:19 AM

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

4 Answers, 1 is accepted

Sort by
0
Amit
Top achievements
Rank 1
answered on 11 Apr 2013, 05:28 AM
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.
0
Ivaylo
Telerik team
answered on 11 Apr 2013, 11:21 AM
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
0
Amit
Top achievements
Rank 1
answered on 12 Apr 2013, 06:21 AM
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.
0
Ivaylo
Telerik team
answered on 12 Apr 2013, 11:42 AM
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
Tags
General Discussions
Asked by
Amit
Top achievements
Rank 1
Answers by
Amit
Top achievements
Rank 1
Ivaylo
Telerik team
Share this question
or