Solved

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - using web developer 2010 express

Posted on 2012-04-05
8
902 Views
Last Modified: 2012-04-11
link to others

I have built a website using web developer 2010 express.  And use oledb to connect to excel on users desktop and get the following error message.
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
I've found hundreds of posts on this and it seems most people download something from microsoft and problem fixes.  Other people have to set program to compile in 32bit mode.
Problem is everyone on here is using vsexpress and I am using web developer express, and I do not see how to change to compile in 32 bit mode to see if this fixes my problem.

Can someone please offer assistance.
The link below shows more details of how others fixed issue.

thank you!!!

http://stackoverflow.com/questions/238625/microsoft-ace-oledb-12-0-provider-is-not-registered
0
Comment
Question by:solarissf
  • 4
  • 4
8 Comments
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37814981
You need to download and install Microsoft Access Database Engine 2010. http://www.microsoft.com/download/en/details.aspx?id=13255
0
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37814994
you can download and install 32 and 64 bit version of access database enging on your system

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255


This should resolve the issue.
0
 

Author Comment

by:solarissf
ID: 37815239
I installed both, same message
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37815260
Did you reboot the machine after reinstallation?
0
 

Author Comment

by:solarissf
ID: 37815636
i unstalled access database objects, I had 2007 and 2010 versions on my pc.  Then I installed 64bit 2010 access database objects, (your link above), then tried other link for 32bit and it said it would not let me since I already had 64bit.  Re-booted and same error message.  
This is driving me crazy.  And the site works locally, just not live.... you can try it out.. its www.fundinception.com.  It shouldnt work for you since you dont have the excel file on your desktop it needs to work though.

any thing else I can do?  I dont need to compile in 32 bit mode?
0
 

Author Comment

by:solarissf
ID: 37816302
after further researching... godaddy.com shared web host will not allow grabbing excel data from users pc to upload.  if this is true... are all shared web hosting companies the same way... godaddy wants me to have a dedicated server.  Is there any way I can convert this excel sheet before uploading data?  I mean for my website to connect to excel file... convert data to acceptable format... then upload?

is this possible
0
 
LVL 17

Accepted Solution

by:
Anuroopsundd earned 500 total points
ID: 37816325
you can check for CSV file format.
0
 

Author Comment

by:solarissf
ID: 37823330
let me know if I should put this in a new post... if so I will do so right away.

I used streamreader to read csv as we discussed and it works locally.  But when I put it on web host it fails with error message below:

Could not find file 'C:"usersdesktop"\comma.csv'.
Line 38:         StreamReader sr = new StreamReader(path+mainDataFile);


 

I was trying to get my webpage to find users desktop automatically, then grab the file called comma.csv.  without uploading anything.

path = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);

mainDataFile = @"\comma.csv";


StreamReader


sr = new StreamReader(path+mainDataFile);




 

From when I'm reading on the web, internet security does not allow a webpage to allow access locally to a users pc.  There has got to be some way to find the file on the users desktop.  What do you think?
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Winform Module - What is the ASP.Net equiv 2 28
edit .asp files 5 31
using CK editor in iframes 5 18
How can I do Unit Testing with Session ? 1 13
Preface This article introduces an authentication and authorization system for a website.  It is understood by the author and the project contributors that there is no such thing as a "one size fits all" system.  That being said, there is a certa‚Ķ
Preface In the first article: A Better Website Login System (http://www.experts-exchange.com/A_2902.html) I introduced the EE Collaborative Login System and its intended purpose. In this article I will discuss some of the design consideratio…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question