Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Wednesday, October 16, 2019 3:26 PM
Hi, I hope that I am posting to the right form as I am pretty new to mdsn. If not, please let me know and I will move my post to the proper form.
I can not work with access because I get the error: "microsoft ace oledb 12.0 provider is not registered" so I was trying to install
Microsoft Access Database Engine 2010 Redistributable
and it did not work because:
You cannot install the 64-bit version of Microsoft Access Database Engine because you currently have 32-bit Office Product installed
after I have received this error I spent days trying to install the product using any solution that the internet has to offer: Installing with passive, remove the files manually, use the control panel etc..
I have come to the conclusion that the only thing that will help me is a cmd command that just finds and removes all the x32 bit versions of the file, however I know a little about cmd. how can I do such operation?
All replies (11)
Thursday, October 17, 2019 3:24 PM ✅Answered
Does the C# test code work with a .accdb file ?
Won'n let me run: namespace oledb command does not exist in the current context. about the file,
Add a reference to System.Data
Wednesday, October 16, 2019 4:03 PM
I spent days trying to install the product using any solution that the internet has to offer: Installing with passive, remove the files manually, use the control panel etc..
AccessDatabaseEngine_x64.exe /passive
(or /quiet) depending on version)
worked for me (I have now both 32 and 64-bit installed (Windows 10)
Wednesday, October 16, 2019 4:14 PM
Yes I have used passive, and it didn't work, with the same error as installing it without passive
Wednesday, October 16, 2019 4:19 PM
or /**quiet ** (if 2016) ?
like in Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing
Wednesday, October 16, 2019 4:30 PM
No error this time, yet when I click "test connection" in VS I get the "the microsoft.ace.oledb.12.0 provider is not registered on the local machine" error
Thursday, October 17, 2019 9:41 AM
Are you sure the 32-bit version is installed ? (AccessDatabaseEngine.exe)
to check :
"c:\Windows\SysWOW64\odbcad32.exe" (32-bit)
odbcad32.exe (64-bit)
Dost it work if you test a connection in C#, like :
string sFile = "E:\\Employees.accdb";
System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand();
System.Data.OleDb.OleDbConnection myConnection = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + sFile + ";Persist Security Info=False;");
myConnection.Open();
Thursday, October 17, 2019 11:48 AM
I want to the path you sayed and the file is there. What should I do now?
Thursday, October 17, 2019 11:50 AM
I want to the path you sayed and the file is there. What should I do now?
Which file ?!
odbcad32 is used to display installed drivers, 32 or 64-bit
Does the C# test code work with a .accdb file ?
Thursday, October 17, 2019 2:38 PM
I want to the path you sayed and the file is there. What should I do now?
Which file ?!
odbcad32 is used to display installed drivers, 32 or 64-bit
Does the C# test code work with a .accdb file ?
Won'n let me run: namespace oledb command does not exist in the current context. about the file,
I cant see it in the given file. all I can see is ACEODBC.dll file as access driver
Thursday, October 17, 2019 5:21 PM
Tested you code, code the error nhandled Exception: System.Data.OleDb.OleDbException: 'E:\Employees.accdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
(as expected, I dont have such DB(
Thursday, October 17, 2019 5:23 PM
I have tried it with existing DB and no error. I think that the solution was as simple as adding the nuget package, but I am not sure I have solved it