Excel Data Provider stuck at "connecting" when you click Test...

Expand / Collapse
 

Excel Data Provider stuck at "connecting" when you click Test Connection


Article ID: 52472 - Last Review: January 23, 2017

PROBLEM

After creating an Excel Data Provider in YourSite Explorer you click the Test Connection button and it gets stuck on "Connecting". 



SYMPTOMS

After some time a fatal error is reported.

"...did not receive a reply within the configured timeout..." 



RESOLUTION

We will need to reinstall the Microsoft Access Database Engine 2010 components.

1. Go to Control Panel >  Programs and Features
2. Uninstall all versions of Microsoft Access Database Engine 2010 present.
3. Click the start menu/button and type in cmd.exe.  Right-click the Command Prompt and Run As Administrator.
4. In the command prompt run the following two commands:

  • choco install -force -y msaccess2010-redist-x64
  • choco install -force -y msaccess2010-redist-x86
NOTE:  The above instructions are for 8.0.X.X.  In 8.1.X.X you skip the last command (only the x64 is installed)

APPLIES TO

MiCC 8.X and newer

Keywords: connecting timeout ODBC query Excel data provider



Rate this Article:
     

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Monday, January 23, 2017
Last Modified By: AndrewMontpetit
Type: FIX
Article not rated yet.
Article has been viewed 11,772 times.
Options