89653

OLEDB.oracle provider not found

Question:

I am hitting a strange problem with an Excel VBA application that accesses an Oracle database. The application works perfectly in development and in test, but when it was installed on to a VM for support to use, it says that it cannot find the data provider or the data provider may not have been installed properly.

Normally, the issue would be that the Oracle Client hasn't been installed with the OLE Database Provider missing, but this is all installed and there is nothing blocking. SQL Developer can access the database, and so I am confused as to what the problem could be.

It is Oracle 12c Client that is being used, and as I said - everything is working fine in development and in test.

Can someone throw some light on to this for me?

Answer1:

Problem was with Excel 2010. A colleague installed a 64bit version of Office 2010 rather than the standard version. When this was installed, it worked. So, be careful when installing Office 2010

Recommend

  • Getting zero results in search using elastic4s
  • RPMs for IDAS IoTAgents GE, from Fiware
  • Lua: Line breaks in strings
  • Clear fused location provider's location for testing
  • Is there a way to save the selected text and highlight it again once the page is refreshed?
  • Can I programmatically choose the Android layout folder?
  • Graphics.CopyFromScreen [Web application] + The handle is invalid
  • How do I configure context broker accept post requests from my remote sensor?
  • Does Mobilefirst provide a provision to access web services directly?
  • Spring Cloud Microservice Architecture Confusion
  • ADO and msqli connections very slow
  • Transactional Create with Validation in ServiceStack Redis Client
  • Hardware Accelerated Image Scaling in windows using C++
  • D3 nodes and links from JSON with nested arrays of children
  • $wpdb not working in file of WordPress plugin
  • Handling un-mapped Rest path
  • The plugin 'org.apache.maven.plugins:maven-jboss-as-plugin' does not exist or no valid ver
  • Pass value from viewmodel to script in zk
  • Display issues when we change from one jquery mobile page to another in firefox
  • Deselecting radio buttons while keeping the View Model in synch
  • Different response to non-authenticated users and AJAX calls
  • PHP - How to update data to MySQL when click a radio button
  • Can I make an Android app that runs a web view in Chrome 39?
  • JSON with duplicate key names losing information when parsed
  • Arrow is showed instead of the material design version hamburger icon. Why doesn't syncState in
  • Updated Ionic CLI but shows previous version (Windows)
  • Timeout for blocking function call, i.e., how to stop waiting for user input after X seconds?
  • Jquery - Jquery Wysiwyg return html as a string
  • How to format a variable of double type
  • Data Validation Drop Down Box Arrow Disappearing
  • How to include full .NET prerequisite for Wix Burn installer
  • Error creating VM instance in Google Compute Engine
  • embed rChart in Markdown
  • How can I remove ASP.NET Designer.cs files?
  • python draw pie shapes with colour filled
  • Is there any way to bind data to data.frame by some index?
  • How to get NHibernate ISession to cache entity not retrieved by primary key
  • How can i traverse a binary tree from right to left in java?
  • How can I use `wmic` in a Windows PE script?
  • Unable to use reactive element in my shiny app