Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine in windows server 2008 rs Share point site

Question

0.00/5 (No votes)

See more:

hi,

i have developed one application in that user uploads Excel/Csv files and in coding i am reading that file for that i have used

Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='text;HDR=Yes;FMT=Delimited' to read the csv and for excel Properties='Excel ;HDR=Yes;FMT=Delimited'

and that application is integrated with Share point, deployed as Sahre point Site and when i tryed to read the file i am getting

Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine error

i tryed with Enable 32 bit Application=True and Load User Profile =true settings but it won't works i have installed all Drivers in that machine but still same problem

the same application works with Normal IIS Website by applying this settings Enable 32 bit Application=True and Load User Profile =true

in IIS 7 Please give me the solution

thanks

Posted 27-Feb-11 19:05pm

anup_k

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

pankajupadhyay29 · Answer 1 · 2011-02-27T19:10:00

Solution 1

I face same problem with windows 7 64 bit and solution work for me is to change platform and configuration to x86 from project properties.

hope this will work for you, please let me know.

--Pankaj

Posted 27-Feb-11 19:10pm

pankajupadhyay29

Comments

anup_k 28-Feb-11 1:26am

hi pankaj from where i can change this

pankajupadhyay29 28-Feb-11 1:28am

go to project-> project properties->build -> platform target

anup_k 28-Feb-11 1:43am

its AnyCPU in my project properties so i think it is x86
but actual problem is the project is working from my solution when we buil it on other System that is windows server 2008 that time it shows problem and there site is integrated with sharepoint

pankajupadhyay29 28-Feb-11 1:44am

this problem is only if you are using Oledb provider with 64 bit OS.

anup_k 28-Feb-11 1:47am

Yes then what is the solution for that

pankajupadhyay29 28-Feb-11 1:50am

solution is to change target platform

pankajupadhyay29 28-Feb-11 1:53am

check the followings
http://social.msdn.microsoft.com/Forums/is/adodotnetdataproviders/thread/45aa44dd-0e6f-42e5-a9d6-9be5c5c8fcd1

http://support.microsoft.com/kb/957570