OleDb exception when trying to make connection with Excel

Question

I am developing a C# Windows Form Application which read and write data to Excel file such as data.xls

I have made my connection string as:

string Excel03ConString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES'";

My data.xls file is in Project's bin folder. I am working on this application from last 4 to 5 days. Till now, my application was working fine. But from today, it starts giving an error

Unexpected error from external database driver (1).

on con.open();

maybe your directory permissions have changed? is it a good ide to acces files from a Bin folder? They should relaly be cleared down when cleaning your solution etc.. — thanatorr
– thanatorr, Commented Oct 12, 2017 at 9:41
I suggest you checking the workbook/worksheet name & file permission. There are multiple causes such like linked worksheet, custom naming or other unexplained ones, hence a stack trace/exception detail may necessary. — Tetsuya Yamamoto
– Tetsuya Yamamoto, Commented Oct 12, 2017 at 9:44
File has full access. Last night, my system has been updated. Is there any connection of this with the error. Even one of my installed windows form app that use Excel file, starts throwing same exception. — 720p Download Watch Dabangg 3
– 720p Download Watch Dabangg 3, Commented Oct 12, 2017 at 9:56

AleRubis · Accepted Answer · 2017-10-24 13:36:44Z

3

It seems to be an error introduced by the last Windows Update.

To avoid this error you can change the provider in connection string to Microsoft.ACE.OLEDB.12.0 instead of Microsoft.Jet.OLEDB.4.0.

https://blogs.msdn.microsoft.com/dataaccesstechnologies/2017/10/18/unexpected-error-from-external-database-driver-1-microsoft-jet-database-engine-after-applying-october-security-updates/

edited Oct 24, 2017 at 13:36

answered Oct 12, 2017 at 9:59

AleRubis

2645 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

720p Download Watch Dabangg 3 Over a year ago

Thanks. When I create setup of my app and using Microsoft.ACE.OLEDB.12.0 in my connectionstring and then install that setup on a machine which is not updated, then how to handle this case. I think it will give error in such scenario.

AleRubis Over a year ago

If it gives error you should install Microsoft Access Database Engine Redistributable from microsoft.com/it-it/download/details.aspx?id=13255

Chou George · Accepted Answer · 2017-10-16 01:35:39Z

2

Remove the following KB to solve this problem
Windows 10 Version 1703 - KB4041676
Windows 10 Version 1607 and Windows Server 2016 - KB4041691
Windows 8.1 and Windows Server 2012 - KB4041693
Windows 7 and Windows Server 2008 R2 - KB4041681
Due to the windows update on the second week of October 2017

edited Oct 16, 2017 at 1:35

answered Oct 12, 2017 at 10:04

Chou George

616 bronze badges

Collectives™ on Stack Overflow

OleDb exception when trying to make connection with Excel

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related