DevOps, CI/CD and Automation

Hi All,

I am running into this error "Provider cannot be found.It may not be installed properly" while I am trying to connect to Oracle from Excel VBA.

I had installed both Oracle 10.1 and Oracle 10.2 in the same machine and is working with .NET applications.My .NET applications works fine.But when I try to connect from within the EXCEL VBA,it gives me this error.

This is my oracle client folder structure

Oracle 10.1 -> C:\Program Files\Oracle\product\10.1.0\Client_1
Oracle 10.2 client -> C:\Program Files\Oracle\product\10.2.0\Client_2
Oracle 10.2 ODAC -> C:\Program Files\Oracle\product\10.2.0\Client_1

As part of working around this error,I have uninstalled my 10.2 and now I just have 10.1 in my local machine.

This is the code snippet where the error occurs in VBA

Set Conn = New ADODB.Connection
Conn.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=datasource;User ID=userid;Password=pwd;CacheType=Memory"
Conn.ConnectionTimeout = 60
Conn.Open

I would really appreciate any help as I have been working around this erro for the last 2 days

Thanks much!