Exception got

Question

Hi,
I've set up Access on server. Why is it still having issue below?

[InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.]

Answer 1

This usually means your system does not have the one or more of the data connectivity library
You may need to choose the correct the setup version (32 bit or 64 bit) based on the bitness of your Microsoft Outlook.

Check this toothe-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine

Answer 2

You have to install the driver.

https://datasavvy.me/2017/07/20/installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing/

Answer 3

Hi all,
Jack,
I ran the project on the server and got the error.

Duane,
After having installed that, I still had the issue when running deployed project.

Answer 4

Hi,
FYI

        OleDbConnection conn2;    
        conn2 = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Jet OLEDB:Database Password=????;Data Source=C:\inetpub\VS2015\House_DB.accdb");    
        OleDbCommand cmd6 = null;    
        OleDbCommand cmd = null;    
        OleDbDataReader reader = null;    

        conn2.Open();    
        try    
        {    
            cmd6 = new OleDbCommand("SELECT pict_desc,file_nm FROM house_pict where house_id=[@](/users/na/?userId=02bb7e8c-7ffe-0003-0000-000000000000)_id and ord_key=[@](/users/na/?userId=a549174b-f4bc-4c2e-8aa7-47b918f260d4)", conn2);    

Answer 5

@Peter_1985 ,

Based on my test, your code works well in my computer.

Please try the following steps to check if it works for you.

First, Please check if you installed the Microsoft Access Database Engine 2010 Redistributable. If not, please download
AccessDatabaseEngine.exe from Microsoft Access Database Engine 2010 Redistributable.(Note: Choose the AccessDatabaseEngine_X64.exe if your computer is 64 bit otherwise choose the
AccessDatabaseEngine.exe)

Second, Please change platform from Anycpu to x64.

Please try the above suggestions, you can contact me for free time if you still have the problem.