Link to home
Start Free TrialLog in
Avatar of crickard62
crickard62Flag for United States of America

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
Avatar of VBRocks
VBRocks
Flag of United States of America image

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.
Avatar of crickard62

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?
I can connect programatically.  It just seem to want to connect in Visual Studio 2008.  I'm stumped.
ASKER CERTIFIED SOLUTION
Avatar of crickard62
crickard62
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial