The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
-
Guys; I have run a code that connect to an excel file on a web service and it worked. now I run the same code on a windows service running on the same host but it gave me the exception of: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Help people,so poeple can help you.
-
Guys; I have run a code that connect to an excel file on a web service and it worked. now I run the same code on a windows service running on the same host but it gave me the exception of: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Help people,so poeple can help you.
You need to install Microsoft Access Database Engine 2010 Redistributable from here: http://www.microsoft.com/en-us/download/details.aspx?id=13255[^]
-
You need to install Microsoft Access Database Engine 2010 Redistributable from here: http://www.microsoft.com/en-us/download/details.aspx?id=13255[^]
Item #4 of the above link states that it is not intended for "
Quote:
... a program called from server-side web application such as ASP.NET ...
So what is the preferred method to access data stored in Excel for an ASP.NET application ? I understand that you don't want to build an OLTP system usign Excel as a datastore ... but I have a situation where there is a spreadsheet which is updated by one department and I was thinking of buidling a simple webpage which would be used as search front-end for folks who do not have "edit" access to the Excel doc. Should be OK? Right?
-
Item #4 of the above link states that it is not intended for "
Quote:
... a program called from server-side web application such as ASP.NET ...
So what is the preferred method to access data stored in Excel for an ASP.NET application ? I understand that you don't want to build an OLTP system usign Excel as a datastore ... but I have a situation where there is a spreadsheet which is updated by one department and I was thinking of buidling a simple webpage which would be used as search front-end for folks who do not have "edit" access to the Excel doc. Should be OK? Right?
If I recall correctly in Win7 Ole JET DB is deprecated and you should use mentioned ACE.OLEDB.12.0. For older systems use JET. This should be installed with office and one of them should be accessible. In my app I use web.config connection: jet for production with older version of WinServer and OLEDB for my Win7 dev machine. I don't know if there is better way.
No more Mister Nice Guy... >: |
-
Guys; I have run a code that connect to an excel file on a web service and it worked. now I run the same code on a windows service running on the same host but it gave me the exception of: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Help people,so poeple can help you.
If your application running in 64 bit machine, change the "Platform target" into X86 in project properties. I hope it will work for you.