Microsoft Access Database Engine 2010 Redistributable

Question

1.00/5 (1 vote)

See more:

Hi All

We have a webapplication in which client has to upload the data in excel file.we are reading the excel file using “Microsoft.ACE.OLEDB.12.0” provider which requires to install Microsoft Access Database Engine 2010 Redistributable .The application is running fine in dev env.

when i move the application form dev to porduction due to some security issue they are not allowd to install Microsoft Access Database Engine 2010 Redistributable .the reason for that only is

The Access Database Engine 2010 Redistributable is not intended:

To be used by a system service or server-side program where the code will run under a system account, or will deal with multiple users identities concurrently, or is highly reentrant and expects stateless behavior. Examples would include a program that is run from task scheduler when no user is logged in, or a program called from server-side web application such as ASP.NET, or a distributed component running under COM+ services.

can anyone explain me the meaning of above reason or give some alernatives.

Posted 14-Nov-11 19:43pm

bhagabatS

Add a Solution

Comments

Sergey Alexandrovich Kryukov 15-Nov-11 2:30am

What exactly is not clear in this statement?
--SA

bhagabatS 15-Nov-11 3:53am

Is there any issue to read the excel data using Microsoft.ACE.OLEDB.12.0” provider in webapplication ??

2 solutions

Solution 1

Forget Access, this is just not serious. Use some other RDBMS based on client-server model. There are some to choose from:
http://en.wikipedia.org/wiki/Comparison_of_databases[^].

—SA

Posted 14-Nov-11 20:32pm

Sergey Alexandrovich Kryukov

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)

Uday Kumar Vuriti · Accepted Answer · 2011-11-15T00:22:00

Solution 2

I think the below link will help you.

http://blogs.msdn.com/b/farukcelik/archive/2010/06/04/accessing-excel-files-on-a-x64-machine.aspx[^]

Posted 15-Nov-11 0:22am

Uday Kumar Vuriti