-3

I want to write to a .accdb file. When I test and do such from localhost it works w/o any issues. However if I try to write to it from my URL it errors. The .accdb is stored in a folder created from within VS called Database.

How should I set up/store the .accdb so I can write to it from the web?

Error message is
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.



Connetion String is
"Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|Testing.accdb"
EDIT if I change the connection string to 12.0 same error message

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
In Resposne To Comment
I am using VS2010 and do not have the option of in my options

In the bottom-left corner of the Options dialog, check the box that says, "Show all settings"

This is what I see under optionsenter image description here

Ramalad Franklin
  • 13
  • 3

1 Answers1

0

What is your server operating system version?You may need to install Access software on your server.

And if your Access is x86,you need to specify the x86 mode to compile your project,instead of using anycpu mode.

You'd better use Microsoft.ACE.OLEDB.12.0,when your database is .accdb.

If not OK, you can try to download and install Microsoft Access Database Engine 2010 Redistributable: url(http://www.microsoft.com/en-us/download/details.aspx?id=13255) .

Ivan.Yu
  • 564
  • 1
  • 4
  • 12