The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. And it works on localhost successfully but not on main server(after upload)

Question

0.00/5 (No votes)

See more:

Hi all, I am facing this problem when i am trying to import data from excel sheet.
It works successfully on localhost but on main server it throws that exception(after uploading).
can anyone solve this problem?
Then suggest me..
Thanks.

Posted 23-May-13 19:26pm

Sujee1

Updated 23-May-13 23:26pm

v6

Add a Solution

Comments

Mayuri Gandhi 29-Mar-14 3:33am

Have you solved this issue???
Plz help me.. I have same problem...

4 solutions

Solution 1

Read This Thread. it may help you.[^]

Posted 23-May-13 19:29pm

Arun Vasu

Comments

Sujee1 24-May-13 4:10am

It is running on localhost. but after uploading on the main server, it is throwing this error.

Solution 2

Install Microsoft Access Database Engine 2010 from the below link

http://www.microsoft.com/en-us/download/details.aspx?id=13255[^]

There are to links 32 bit and 64 bit depending upon your system configuration
download the exe.

Posted 23-May-13 21:05pm

Nirav D Parmar

Comments

Sujee1 24-May-13 4:13am

I have already installed it.And It is running on localhost. but after uploading on the main server, it is throwing this error.
I need your help if you can?
Thanks.

Solution 3

See HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"[^].
Cheers
Andi

Posted 23-May-13 21:14pm

Andreas Gieriet

Comments

Sujee1 24-May-13 4:21am

Dear Andreas,
I have already installed it.And It is running on localhost. but after uploading on the main server, it is throwing this error.

Andreas Gieriet 24-May-13 8:14am

Does the server fulfill the preconditions as stated in the link above?
Cheers
Andi

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sujee1 · Accepted Answer · 2013-05-24T19:53:00

Dear all, As i am using GoDaddy.com.
And GoDaddy hosting accounts do not support accessing information from an Excel Database.
So I have changed entire code.
In GoDaddy, You can import a CSV file into a MS SQL database, but not a .XLSX file.
For more details visit this link-
http://support.godaddy.com/groups/web-hosting/forum/topic/using-excel-spreadsheets-on-website

Thanks to everyone for their Ideas. :-)

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. And it works on localhost successfully but not on main server(after upload)

4 solutions

Solution 4

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. And it works on localhost successfully but not on main server(after upload)

4 solutions

Solution 4

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us