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
Rank 1
Oracle Client has been deprecated and now suggested to use Oracle.DataAcccess which can't be configured in Test studio.
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
Test Studio Trainings
Rank 1
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.
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
Test Studio Trainings