Recently I upgraded to .Net Framework 3.5 SP1. The service pack introduced a host of bug fixes, along with some pretty cool enhancements too.
After installing the service pack, one of my web applications immediately started throwing the following exception:
The .Net Framework Data Providers require Microsoft Data Access Components(MDAC). Please install Microsoft Data Access Components(MDAC) version 2.6 or later.
The code that was throwing the exception tries to open an OleDb connection to read data from an excel spreadsheet:
string conStr = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0;", filePath);
OleDbConnection objConn = new OleDbConnection(conStr);
objConn.Open();
...
It seems to me that this component may have been included in previous versions of the framework, and has since been removed. Anyway, I downloaded and installed the latest MDAC, and sure enough, it fixed the problem!
I just started receiving this prompt. I went to the Microsoft site to download the latest MDAC, but Vista is not listed as a supported operating system. Are you using Vista? Thanks.
This was on a windows 2003 server. But if windows XP is supported, there is a good chance Vista 32bit is as well. My guess is that the page was created before Vista’s release, and they didn’t update it.