Database action for Oracle

Hi all,
Did anyone try establishing connection to Oracle? I am getting below error while doing so.
From the same machine I am able to hit same Oracle DB with other tools. Any help please?

Database.Connect ConnectionString:“Provider=OraOLEDB.Oracle.1;Password=xxxxx;Persist Security Info=True;User ID=xxxx;Data” Connection=> SQLConnection
Database.Execute Connection: SQLConnection Statement: “select * from table1” Timeout:30 Result=> QueryResult
Console.Write Message: QueryResult

Checking script…
Loading robot…
Running script…
L4:0 Cannot connect to Data Source: The ‘OraOLEDB.Oracle.1’ provider is not registered on the local machine.

1 Like

Hi @Murali,
Try to create a DSN in your system and then try to connect Oracle DB using the DSN.

Create DSN


Thanks a lot @Ranjith I will try this option.

1 Like