crickard62
asked on
Unspecified error when performing Add Connection for MS Access in Visual Studio 2008
When I try to do an "Add Connection" to the Data Connections tree in Server Explorer to a MS Access database file (.mdb), I get a dialog box that displays "Unspecified error". This occurs when I click the Test Connection button and the OK button on the Add Connection dialog. The .mdb file was created using MS Access 2003 (11.8166.8221) SP3 on XP SP3. The development machine has MDAC 2.8 SP1 on Windows XP SP3 installed. VS.NET 2008 is version 9.0.21022.8 RTM with .NET Framework version 3.5 SP1
You know, I don't know the answer to that question, however, what provider are you using? OleDb or ODBC? You may try using OleDb.
ASKER
I tried both the .NET Framework Data Provider for ODBC as well as the .NET Framework Data Provider for OleDB. I'm going to try a reinstall.
Well, before you do that, can you try connecting to it programatically?
ASKER
I can connect programatically. It just seem to want to connect in Visual Studio 2008. I'm stumped.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.