This project is read-only.
1
Vote

Problems with Microsoft.Jet.OLEDB.4.0 in windows server 2012

description

Due the error "The ‘Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine" using this library in a .net web app and SSIS package...

we have discover that this driver is not valid any more in this kind of 64 bits OS, so we have made a change in order to run the Excel Helper library in the ExcelSheetHelper.cs file: (attached on this comment)

string _xlsConString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=Excel 12.0";

so now both connection string _xlsConString and _xlsxConString runs the same driver (Microsoft.ACE.OLEDB.12.0)

Now app and packages works great, processing all kind of excel files.
More details in:

http://www.edbdata.com/blog/solution-the-microsoft-jet-oledb-4-0-provider-is-not-registered-on-the-local-machine-for-windows-server-2012/

file attachments

comments