locked
Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine RRS feed

  • Question

  • Hello,

    I am am attempting to connect to a OLEDB data provider (ms access 2010). I have ms access 2010 installed on my local drive but I am receiving a System.InvalidOperationException, telling me that i do not have the database program installed, when I try to open a connection to the database file I saved in a 2002-2003 format.

    here is the connectionstring in my program:

     dbProvider2 = "Provider=Microsoft.ACE.OLEDB.12.0;"
            dbSource2 = "Data Source =" & AppDomain.CurrentDomain.BaseDirectory & "Late Students Database 2003.mdb" ' Your address may be different
            con2.ConnectionString = dbProvider2 & dbSource2


            con2.Open()

    after consulting other forums I have been told that the provider I have defined is that for a access 2007 & 2010 database programs. is this the correct connectionstring?

    thanks for reading my message.

    namso1902

    Tuesday, April 3, 2012 10:28 PM

Answers

  • Hi,

    It is either mispelled (seems correct to me), or not installed (including using the x86 version from a 64 bit process or the other way round). You can download the provider(s) from http://www.microsoft.com/download/en/details.aspx?id=13255.

    Please always mark whatever response solved your issue so that the thread is properly marked as "Answered".








    Wednesday, April 4, 2012 11:26 AM

All replies

  • Hi,

    It is either mispelled (seems correct to me), or not installed (including using the x86 version from a 64 bit process or the other way round). You can download the provider(s) from http://www.microsoft.com/download/en/details.aspx?id=13255.

    Please always mark whatever response solved your issue so that the thread is properly marked as "Answered".








    Wednesday, April 4, 2012 11:26 AM
  • One installed the ACE provider, just open the project properties, Build Option --> set the Platform Target X86.

    Friday, May 18, 2012 6:52 PM