Ask a new question

32-bit Excel Click-To-Run & Oracle OLEDB

I am struggling to get my 32-bit Excel (click-to-run) to use my 32-bit Oracle OLEDB provider. I know the Oracle client is correctly installed as I have a separate 32-bit .NET application that can connect to my Oracle database with the OLEDB provider without any issues. In Excel I can see the provider listed but when I select it and press the Next button I get an error saying that it cannot find the OraOleDBpus12.dll file. The file definitely exists in the client bin folder however.

I have run procmon to see if it would shed any light on what is going on and it confirms that everything is correctly in 32-bit-ness. It also presents a clear picture of how Office click-to-run manages its virtualized environment and I can see it correctly using the PATH environment variable to locate files. I should also say at this point that the first entry on my PATH variable is the Oracle client bin folder. The output all looks like it is doing what it is supposed to until it reaches a certain point in the logging when, for some reason, it stops looking in the Oracle client bin folder as part of the search sequence and just goes straight to C:\Windows\SysWOW64. Both of these situations are shown below.

In order to further check that the problem lies with how Office is attempting to load the provider, I manually copied the OraOleDBpus12.dll into C:\Windows\SysWOW64 and tried again. This time Excel complained about not being able to find a different file, OraOleDB12us.dll. I copied that into C:\Windows\SysWOW64 and tried once more. The result on this occasion was a very different message, claiming that it could not determine the text for a specific message, most likely because Excel had also failed to correctly map the Oracle client oledb\mesg folder contents to its virtual environment.

Is this a bug? If not, then why does Excel stop using the PATH environment variable to locate files part way through the process?

I'm using:

Windows 10 Pro version 1903 OS Build 18362.239

Microsoft Excel for Office 365 MSO (16.0.11901.20070) 32-bit

Oracle 12.2.0 client 32-bit.

Thanks in advance

Michael

Hi Michael,

 

Thank you for sharing the experience with us.

From your description, the issue is that you cannot use Oracle OLEDB provider in Excel to connect to your Oracle database.

 

Firstly you may refer to the information in this articles and see if it helps:

Connect OLE DB data to your workbook

Connecting to Oracle Database through Excel

 

And to troubleshoot the issue, I'd like to confirm information below:

 

1.You mentioned "In Excel I can see the provider listed but when I select it and press the Next button I get an error saying that it cannot find the OraOleDBpus12.dll file."

When the error message persists, please capture a screenshot of it.

 

2.To know the details of your Office, in Excel please click File>Account, then on the right side of the window, capture a full screenshot of the Product Information.

 

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

 

Best regards,

Tina

• Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi, Tina.

Please see the screenshots you requested.

First the error message...

To demonstrate the file exists on the PATH...

Now the product information...

And finally, for good measure, the about window...

Thanks

Michael

[Private message is removed by forum moderator]

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Michael,

 

Thank you for posting back and sharing the details.

For further troubleshooting, you may try following:

 

1.Since you are not using the latest version 1907(Build 11901.20218) of Office, update Office via File>Account>Update Options>Update Now, see if it would help.

 

2.Try Online Repair Office to see if it would fix the issue.

 

Feel free to share with us your test result.

 

Best regards,

Tina

• Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Michael,

Feel free to share any update with us.

Thanks,

Tina

• Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi, Tina.

No, it didn't resolve the problem, but then it did feel more like a stock response than I proposed remedy.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Michael,

Thanks for your update. Please allow me some time to do investigation for the issue. I will post back as soon as I get any update. Appreciate your patience.

Regards,

Tina

• Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Michael,

 

Sorry for my late response. I did some research and found that the issue is a common issue that happens to different products when trying to connect with Oracle. Unfortunately I didn't find the root cause of the issue. Really sorry for that.

 

To help you do further investigation for the issue, I recommend you post the question in our MSDN forum which deals more advanced issue, members and engineers have more experience and will help you further.

 

Your understanding is appreciated.

 

Best regards,

Tina

• Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 5, 2021 Views 449 Applies to: