Im a trying to build a msi file but have a problem.

I use the "setup project" template in visual studio pro tobulid a msi file for my application.I need sql express for my app. So i am trying to build an installation file(msi)with my app and sql Express.

When i run the installation file i have created the sql Express run into an error, it says something about another installation is already in progress". Yes my msi file is running in the back ground, wich have started the sql express- installation.

Anyone who knows how to get around this?

I just want to install both these applicationsat the same time!

Regards
Marreoragarn

Exactly... so just to go your project properties dialog, select PreRequisites, and then click the checkbox for SQLExpress. After you build, install by using setup.exe instead of mysetup.msi...

Wscript is notvalid in Windows Installer vb script. You're not running in WSH. Just use CreateObject all the time, not wscript.createobject.

SQL Express is also using an msi setup, and you cannot run two msi setups concurrently. So ninstead of launching the sqlexpress setup from a custom action, you should install it as a prerequisite, i.e. use a exe that will run the two msi setups in sequence.

Exactly... so just to go your project properties dialog, select PreRequisites, and then click the checkbox for SQLExpress. After you build, install by using setup.exe instead of mysetup.msi...

So if I erase the custom action and selecting the sql Express under prerequisites, then i should be able to install these two program in a sequence if I clicking on the setup.exe instead of the msi-file?

The setup.exe is automaticly generated when rebuilding the project? It's a smaller file than the msi-file!

Regards

Matz

The sql Express folder is generated, with sqlexpress_setup.exe inside,but the installation of the file is not starting!

I have done as you said, (I think)!

What can be the problem now?

/Matz

It works!
SQL Express did not install because I already had it on my computor! When I deleted it the setup.exe installed it.

Thanks fort your answers!

Sorry, I have another question also!
Anyone knows how to connect a database (install a database) with a script from custom Action?

Regards
Matz

Are you running this on your Visual Studio computer? It won't install if it's already installed.

Also, what's sqlexpress_setup.exe? I would have expected setup.exe, with a SQLExpress folder and in that folder a SQLExpress32.exe...

Are you running this on your Visual Studio computer? It won't install if it's already installed.

Yes I know that now :)

The file is named setup.exe from build!

I have a problem with Custom Action. I trying to run this script from a Custom Action.

When the installer(setup.exe) runs, it starts fine but when setup.exe shall run my VB-script it says that i could not run the script. Whats wrong?

The script working fine alone, I mean it works when i manually run it by clickingon it!

Se the script below:

Dim WshShell, oExec
Set WshShell = CreateObject("WScript.Shell")
Set WshNetwork = WScript.CreateObject("WScript.Network")

Dim MyString
MyString = "sqlcmd -S " & WshNetwork.ComputerName & " -E -i drop.sql -i CreateWhsDB.sql -i alla_SP.sql"

Set oExec = WshShell.Exec(MyString)

Wscript is notvalid in Windows Installer vb script. You're not running in WSH. Just use CreateObject all the time, not wscript.createobject.