ASP.NET system error regarding MS Access
Hi
I have faced a problem regarding my application database error:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
My database works fine in my local-site.
Discussions are closed to public comments.
If you need help with AppHarbor please
start a new discussion.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
Support Staff 1 Posted by rune on 21 Oct, 2016 02:44 AM
Hi,
The MS Access drivers aren't installed on the application servers, so you'd need to include those with the application if you want to run an Access database. The primary reason we don't support access databases is that it's very rarely a good idea to use those on a platform such as AppHarbor's -- the storage isn't persistent, so if you save data locally it'd be wiped on any subsequent deployments including regular maintenance.
You might want to consider using a different database type instead -- there are a lot of options in the add-on catalog, but you can also get for instance a SQL Server instance from AWS RDS starting at around $15/month. They can easily be integrated with your AppHarbor app and provides more consistent performance and availability while being better suited for scaling.
Best,
Rune