none
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

    Question

  • I have Visual Studio 2010 Beta 2 and Access 2010 Beta installed on my computer

    I have Windows 7 64 bit but i hope both vs 2010 and Access 2010 Beta are 32 bit guessing from their process name
    (devenv.exe *32 and MSACCESS.EXE *32)

    I installed 2010 Office System Driver: Data Connectivity Components 32 Bit
    And still in my C# program, the statement

    OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;" + @"data source=C:\insructionSet.accdb");

    and conn.Open() produces the error

    "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine"
    The database was created in Access 2010

    In another C# program
    private OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.JET.OLEDB.4.0;" + @"data source=C:\tax.mdb");

    and conn.Open() works fine

    Please Help

    • Edited by Vivek Raj R Monday, November 30, 2009 5:49 AM Error in previous post
    Monday, November 30, 2009 5:47 AM

Answers

All replies