Wednesday, 3 October 2012

MICROSOFT.ACE.OLEDB.12.0 Provider is not register on local machine

Hello Guys,
I developed an internal application with 2010, it creates oledb connection and opens excel file.
 I started the coding when I had office 2007, when other people tried to install it on their machines, these with office 2007 would be fine but these with office 2010 would get error message
 "The 'Microsoft.Ace.OLEDB.12.0' provider is not registered on the local machine".

Then I found Following Solution For Above Problem

It Will solved in Following Steps

STEP 1 )
Download Following Files
                1)Acess Database Engine.exe

STEP 2 ) Install It on your Hard Disk
  1. Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
  2. Follow the instructions on the screen to complete the installation.

STEP 3)  Use This Download As

  1. If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”.

    If you are connecting to Microsoft Office Excel data, add the appropriate Extended Properties of the OLEDB connection string based on the Excel file type:

    File Type (extension)                                       Extended Properties
  2.  Excel 97-2003 Workbook (.xls)                              "Excel 8.0"
    Excel 2007 Workbook (.xlsx)                                 "Excel 12.0 Xml"

  3. If you are an application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
  4. If you are an application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”
Step 4)  Remove the Exe From Your hard Disk

To remove the download file itself, delete the file AccessDatabaseEngine.exe
  1. On the Start menu, point to Settings and then click Control Panel.
  2. Double-click Add/Remove Programs.
  3. In the list of currently installed programs, select “Microsoft Office Access database engine 2007” and then click Remove or Add/Remove. If a dialog box appears, follow the instructions to remove the program.
  4. Click Yes or OK to confirm that you want to remove the program.

Hope this will help you
Thank You So Much For Visiting
Chetan V.

No comments:

Post a Comment