none
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

All replies