Hi Steve,
Thank you posting!
Based on my understanding, you need your user's machine to install the SQL
Server Express before the installation of your application.
The general convention to do this is via the bootstrapper or using a Launch
condition. Since currently we don't provide a bootstrapper for the SQL
Server Express. I suggest you take the Launch condition approach. You can
prompt the user to install the SQL Server Express product if the Launch
condition failed.
Please refer to the following MSDN web site for the further information
about using launch condition:
Launch Condition Management in Deployment
http://msdn2.microsoft.com/en-us/library/ay12wede.aspx
If you really want to invoke the SQL Server Express's installation from
your application's installation, you can use a type 50 CA to launch an
executable to install it, such as : [CDSQLEXPRESSDir]setup.exe (CA' Target
value). You may need to use the [SourceDir] property to get your
application installation package's root directory, then use a CA script to
construct the custom property [CDSQLEXPRESSDir], which is the directory of
the SQL Serve Express's installation setup program in the CD.
By the way, redistribute our SQL Server Express product needs registration.
I hope the above information helps, if you have any questions or concerns,
please do not hesitate to let me know. I am standing by to help you.
Thanks!
Best regards,
Gary Chang
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
steve - 26 Jul 2006 10:21 GMT
Hi Gary
Thanks for the response
What is a CA script?
PS
I have registered SQL server express for redistribution
Regards
Steve
> Hi Steve,
>
[quoted text clipped - 55 lines]
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
Gary Chang[MSFT] - 27 Jul 2006 04:56 GMT
Hi Steve,
>What is a CA script?
I mean a custom action which invokes a VBScript, that VBScript could be
used to manipulate string and specify a property of the installation
package. Please refer to the following link for a CA script sample:
http://mokk43.spaces.msn.com/blog/cns!ADDF398B4E24BB50!106.entry
Thanks!
Best regards,
Gary Chang
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
You can't, but you can write a custom action that launches that exe. The
SourceDir and OriginalDatabase properties both say something about where the
install is running from (thje CD) and can be parsed to locate your sql
setup.
However what you're doing might not work anyway. If the SQL install is
MSI-based it will fail:
http://ablog.apress.com/?p=1135#more-1135
which is why a separate launcher that starts the SQL setup then yours is a
more normal way to do things.

Signature
Phil Wilson
[Microsoft MVP-Windows Installer]
Definitive Guide to Windows Installer
http://apress.com/book/bookDisplay.html?bID=280
>I want to install sql server express after checking if the user needs it
>and
[quoted text clipped - 9 lines]
> Regards
> Steve