Issue: While running an SQL agent job, if you experience following mentioned issue here is the resolution
Resolution: To resolve this issue, we need to install ' Microsoft.ACE.OLEDB.12.0 Driver'.
Post installation Verification:
If you have installed 64 bit driver then you can run odbcad32.exe from run prompt and you'll be presented with following mentioned screen
If you have installed 32bit - try running this c:\Windows\SysWOW64\odbcad32.exe
https://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=vstsdb
Resolution: To resolve this issue, we need to install ' Microsoft.ACE.OLEDB.12.0 Driver'.
Post installation Verification:
If you have installed 64 bit driver then you can run odbcad32.exe from run prompt and you'll be presented with following mentioned screen
If you have installed 32bit - try running this c:\Windows\SysWOW64\odbcad32.exe
https://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=vstsdb
Warm Regards,
Chhavinath Mishra
Sr. Specialist Database Administrator
No comments:
Post a Comment