Last post May 31, 2013 07:13 PM by dolot
May 29, 2013 11:39 AM|dolot|LINK
I have a website with a data connection. The data connection reads as such:
Works great on my machine, but when I transfer it to another developer's box, it give the error:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Which is, of course, because he doesn't have access installed on his computer.
But now the main issue is when we send this to the customer for his review. The customer may not have Access, or not the same version
as mine. So how do I take care of this in deployment? Is there a way to make sure the VS 2012 publish tool includes the appropriate drivers, or is there a more generic driver I should be using - something more intrinsic to the .net framework?
May 30, 2013 10:55 PM|Pengzhen Song - MSFT|LINK
I think you have to install the driver in the server.
And refer the similar thread
But for window form:
Hope it can help you
May 31, 2013 10:55 AM|hans_v|LINK
Convert your accdb file to a mdb file, and use the Microsoft.Jet.OleDb.4.0 driver instead, which is installed on any windows machine by default..
May 31, 2013 07:13 PM|dolot|LINK
Thanks. I'll give that a try and see how it goes.