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
L4:0 Cannot connect to Data Source: The ‘OraOLEDB.Oracle.1’ provider is not registered on the local machine.