Click here to Skip to main content
Search within:



Next

Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Sign Up to vote bad
good
See more: ASP.NET
Hi,
 
In my application,when i import excel data to sql server 2008
i got the following error,
Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
 
its work fine in my local machine but in server it display the above error
Posted 30 Dec '12 - 19:52
Ganesh MS434
Add a Solution


1 solution

Because on your local machine the used components(excel,access,word) are installed. But on the server for security reason these components are not installed, that's why you are getting this error. Try the following solution:
http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/1d5c04c7-157f-4955-a14b-41d912d50a64[^]
  Permalink  
Posted 30 Dec '12 - 21:51
Zafar Sultan4K
Comments
Ganesh MS - 31 Dec '12 - 4:03
MS office 2007 is also installed in Server but same error displayed In server 64 bit os 32 office In my machine 32 bit os 32 bit office
Zafar Sultan - 31 Dec '12 - 4:08
There are two solutions in the link provided above they both work for 64 bit OS. Try both of them. If niether works tell us again.
Add a Solution

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 OriginalGriff 198
1 Sergey Alexandrovich Kryukov 159
2 Richard MacCutchan 150
3 Maciej Los 136
4 Tadit Dash 110
0 Sergey Alexandrovich Kryukov 10,264
1 OriginalGriff 7,937
2 CPallini 4,201
3 Rohan Leuva 3,522
4 Maciej Los 3,135


Advertise | Privacy | Mobile
Web02 | 2.6.130523.1 | Last Updated 31 Dec 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid