renejdm
Posts: 26
Joined: Sat Sep 13, 2014 1:46 pm

Another problem with prerequisites

Hi,

In my application I require SQL Server Compact 3.5 to be installed in the global assembly cache (GAC). On the prerequisites page you have an option for installing the 32-bit and 64-bit version of SQL Server Compact 3.5. The problem is that these files are downloaded to the client in a zip file. So the client has to select a folder to unzip the files and then they have to run the two separate files in order to install them. I am sure you can understand that this is not ideal. My clients are not computer savvy. I would like you to fix this so that when you choose to run SQL Server Compact 3.5 it will install the 32 bit version and also install the 64-bit version on 64-bit operating systems.

Right now I have coded the start-up of my application to check if SQL Server Compact 3.5 is installed in the GAC. If not, then I install the files from a sub directory which I have included in the installer. This works but it is not ideal. Because this installation runs the first time they actually start the application. But it should be done by the installer. By the way I am using the professional version of Advanced Installer. I tried to set this up as a custom action run from a .bat file but I was unsuccessful. Correct me if I am wrong, but the professional version is not able to run batch files.

Signed

Very disappointed with the "professional" version
renejdm
Posts: 26
Joined: Sat Sep 13, 2014 1:46 pm

Re: Another problem with prerequisites

Hi,

Is someone able to respond to this post?

Rene
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Another problem with prerequisites

Hello Rene,

I apologize for my delayed reply.

Indeed, our predefined "SQL Server Compact 3.5 SP2 32-bit" and "SQL Server Compact 3.5 SP2 64-bit" prerequisites use by default a self-extracting EXE. We'll try to add an improvement in a future version of Advanced Installer so that the predefined prerequisites in cause to use right their installation files. In this way the user won't have to manually launch the extracted MSI.

Until then, as a workaround, you can proceed like this:
1. run the "SSCERuntime-ENU.exe" setup in order to extract the 32 and 64-bit MSI setups
2. create a new project and go to "Prerequisites" page
3. add our predefined "SQL Server Compact 3.5 SP2 32-bit" and "SQL Server Compact 3.5 SP2 64-bit" prerequisites
4. go to "Setup Files" tab, select the "Use files from disk" option and select the "SSCERuntime_x86-ENU.msi" for the 32-bit prerequisite and the "SSCERuntime_x64-ENU.msi" for the 64-bit prerequisite
5. build and test your project

Also, our "Custom Actions" support is available starting with the "Professional" edition of Advanced Installer and you should be able to run a batch file by using a "Professional" project type. Just add the BAT file in "Files and Folders" page and, then add a "Launch file" custom action having a reference to the BAT file in the "File to launch" field. Also, you can take a look on our "Launch a CMD or BAT file" article which should be useful.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
renejdm
Posts: 26
Joined: Sat Sep 13, 2014 1:46 pm

Re: Another problem with prerequisites

Hi Daniel,

Sorry for this late reply. I will try the workaround and post back my results. As for the .bat file, I already did exactly what you are suggesting but it did not work. If I get the workaround to work I will try again the .bat file, although my needs are pretty complex so I don't think I want to mess around with what I have already set up, as it works.

Rene
renejdm
Posts: 26
Joined: Sat Sep 13, 2014 1:46 pm

Re: Another problem with prerequisites

Hi Daniel,

I tried your workaround and it DOES NOT work!

My suggestion is that you create a small application on your end using SQL Server Compact 3.5 so you can actually test your own ideas. Once you have worked out the bugs please post back here and let me know that you finally have a solution that actually works.

Respectfully,

Rene
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Another problem with prerequisites

Hello Rene,

I'm not sure why the workaround didn't worked in your tests. The workaround was tested before being posted by me and I've now implemented and tested it again on a Windows 7 x64 clean machine. I've attached this sample created with version 11.6.2 of Advanced Installer which I've successfully tested on a Windows 7 x64 machine. The sample will be available for download until 24 November 2014.

Can you download and test the above sample and let us know if this works? Also, for testing purposes we recommend to be used virtual machines with clean snapshots, in this way you can easily revert to a clean snapshot of your machine every time when something goes wrong.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
renejdm
Posts: 26
Joined: Sat Sep 13, 2014 1:46 pm

Re: Another problem with prerequisites

Hi Daniel,

Thanks for the sample. I will test it and get back to you.

Rene

P.S. I am always using virtual machines with clean snapshots for testing.
renejdm
Posts: 26
Joined: Sat Sep 13, 2014 1:46 pm

Re: Another problem with prerequisites

Sorry, I was not able to download the sample because I was too busy. Please post the sample again and I will download it. Why don't I receive emails when this thread has a new post?

Rene
renejdm
Posts: 26
Joined: Sat Sep 13, 2014 1:46 pm

Re: Another problem with prerequisites

Forget about the email update. I just noticed that you have to check a box at the bottom of the page. Please still send the sample. I should get an email when you update this thread.

Rene
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Another problem with prerequisites

Hello Rene,

I've attached a new sample created with version 11.6.3 of Advanced Installer which I've successfully tested on a Windows 7 x64 machine. The sample will be available for download until 31 December 2014.

Let us know if this helped.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Common Problems”