DevOps, CI/CD and Automation

Hi,

I have installed ODAC 11.2.0.1.2 on client machine.

I am trying to populate data in excel (2002) using VBA code. I used VBA ADODB.Connection & OraclOleDb provider with connection string - Provider=OraOLEDB.Oracle.1;Data Source=<Full TNS string>;User Id=xxx;Password=xxx;

I have verified and found registry enteries for OraOleDB11.dll.

However when i run the code i get the following error - Provider cannot be found. It may not be properly installed.

On further investigation i found the code works fine on machine which have Oracle client (9i/10g) installed. I had thought that ODAC do away with the need to install the full Oracle client as it installs the Instant client and my code should have worked fine.

Can someone please provide some insights on it or any other options.
Note - The code runs without any issues if I use MSDAORA.1 but is very slow as compared to performance of OraOleDB provider. (1 min (OraOleDB) vs 8-9 mins (msdaora) to retireve 15,000 records with 25 colums)

Thanks
Kamlesh