Clickonce deployment of the new Access Database Engine 2010

Question

4.33/5 (3 votes)

See more:

, +

Firstly. please forgive me for this lengthy question.

I have developed a C# Winforms app. which must be ClickOnce-deployed. The target machines can be XP, Vista, or Win7, and they can be of x86 or x64 flavors. The database is an external .mdb and the data layer originally was using the Microsoft.Jet.OLEDB.4.0 provider. Additionally, the solution contains Crystal Reports. A problem arose when deploying to 64-bit machines. While the Crystal Reports bootstrapper manifest contains the proper elements to decide whether to install the x86 or the x64 components for Crystal, and does install correctly, the Jet engine is another story. Jet.OLEDB.4.0 does not support 64-bit systems and therefore data access on 64-bit machine fails.

I see that Microsoft has released new versions of the Access Database Engine with 64-bit support. The installers are AccessDatabaseEngine.exe (x86) and AccessDatabaseEngine_X64.exe (x64), which must be installed on the target machine. The x64 version will only install on a 64-bit system.

I have made the changes to my solution so that the data provider used is the new Microsoft.ACE.OLEDB.12.0 which for my purposes supersedes the Microsoft.Jet.OLEDB.4.0 provider.

So, I need to include the newer version of the Access Database Engine as a Publish Prerequisite.

The questions:

Do I need to generate a Bootstrapper Manifest or has Microsoft provided one somewhere?

Secondly, if I must generate a Bootstrapper Manifest, how do I find out the requisite information? Namely:
PublicKey for each, AccessDataBaseEngine.exe and AccessDatabaseEngine_x64.exe,
InstallConditions for each, etc.

Thanks so much for any useful comments or suggestions.

dragoguzzi

Posted 23-Jun-10 10:00am

dragoguzzi

Add a Solution

2 solutions

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)

Member 1965642 · Answer 1 · 2011-04-14T00:04:00

Solution 2

The Installation of AccessDatabaseEngine.exe or AccessDatabaseEngine_x64.exe depends not only from the 32-Bit or 64-Bit machine, but also from eventual installed Office 32 or 64 Bit.

I search a complete Bootstraper Package for AccessDatabaseEngine2010.

Is it possible to find a Bootstraper Package for AccessDatabaseEngine2010 by Microsoft or elsewhere?

Posted 14-Apr-11 0:04am

Member 1965642

Comments

Member 1965642 19-Apr-11 5:46am

I search a complete Bootstraper Package for AccessDatabaseEngine2010 also.

Member 1965642 · Answer 2 · 2011-03-29T04:51:00

My Question:

Do I need to generate a Bootstrapper Manifest or has Microsoft provided one somewhere?

Secondly, if I must generate a Bootstrapper Manifest, how do I find out the requisite information? Namely:
PublicKey for each, AccessDataBaseEngine.exe and AccessDatabaseEngine_x64.exe,
InstallConditions for each, etc.

Thanks so much for any useful comments or suggestions