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

Hi,
I cannot access your doc. Which setup should be uninstalled?

Answer 2

Hi,
I did uninstall 32-bit version (of this) already. Can you help to issue below?

Answer 3

@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.

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

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.