OleDB Excel connection hangs with no exception thrown
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-03-18 10:41 AM
Hi,
We have been successfully querying data from a Excel (XLSX) file using OleDB via the "Provider=Microsoft.ACE.OLEDB.12.0" driver. This has been working fine until last Friday when suddenly it has started failing. When the control reaches the OleDB open connection stage, the process just hangs indefinitely without throwing any exception. Has anyone else faced such issues with OleDB when it suddenly stops working? Any hints or tips on how to resolve this? We have already done a Repair/Reinstall of Microsoft Office on this machine, but it still does not work.
Thanks
MK
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-03-18 01:15 PM
Something must have changed if it worked before. If the BP logic is the same, then the target file must be different somehow. Possibly the machine drivers have changed, but I guess this is unlikely.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-03-18 07:31 AM
Hi John,
Thanks for your response. We resolved this issue. For benefit of anyone else, I want to share the root cause. It turns out that a Windows update for ""Skype for Business 2016"" caused the Office 2010 OleDB driver to start failing. When we uninstalled this Windows update, it started working
MK
