On the installer we used SQLDMO to prepopulate the sql servers on the target
machine in a combo box and also added logic to avoid stomping a database on
an unsupported version of sql server if the user selects an unsupported sql
server from the dropdown but we ran into a problem when SQLDMO wasn't
returning the correct SQL build version number.

The next approach I thought of was to write a SQL select to extract the
build version of the SQL Server and assign it to a WiX property which I can
evaluate to show a dialog which informs the user of the un-supported SQL
Server. I know about SqlString but I need this to run on the click on of a
"Test Connection" button just like a custom action.

Is there a way from WiX to assign a property the results set from a
SQLString on the click of a button or something like this thread talks
about?
http://www.nabble.com/SQL-Select-statement-with-an-ampersand-character-won%27t-build.-to3735082.html#a3735082
Thanks,
Jacob
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users

Reply via email to