Dec 18, 2014 12:38 PM|Cheng Bao|LINK
I use new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=uploadedfile;Extended Properties=""Excel 8.0;HDR=NO;IMEX=1""");to process uploaded excel file, however I got The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine
error on production machine.
I search some solutions, download and installed
Microsoft Access Database Engine 2010
2007 Office System Driver: Data Connectivity Components
still I got same error, then I followed this link
Enabled "enable 32-bit applications" on application pool, then I found the whenever I try to connect the website, the application pool will stop, and give me service unavailable error. So, instead of install full office suit software on production web server,
what should I do?