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 Source:6236=host123.company.net/XY01CCD.CT.company.net” Connection=> SQLConnection
Database.Execute Connection: SQLConnection Statement: “select * from table1” Timeout:30 Result=> QueryResult
Console.Write Message: QueryResult

ERROR:
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

2 Likes

Thanks a lot @Ranjith I will try this option.

1 Like