I'd be interested in seeing your solution, Peter. Can you post your solution
on the Wix-users list for future reference? I feel this shouldn't be hard,
but if you already have it, then why reinvent the wheel!

Thanks in advance.


On 3/13/07, pobox77 <[EMAIL PROTECTED]> wrote:


Thanks Dana,

I've just found the same solution about an hour ago.

Just a note for people having similar problem:

The property used by the radio button and in the condition must be a
global
property
(e.g. the name of it should only have capitals) otherwise it doesn't work.

Peter


Dana Gutride wrote:
>
> This is not possible within the sql database tag right now.  There is a
> bug/feature request in for this exact functionality, but as far as I can
> tell, it hasn't been added yet.  The only way to do this is to have two
> sqldatabase tags in separate components and then add conditions for the
> components based on the radio button's property.
>
> Dana
>
> On 3/13/07, pobox77 <[EMAIL PROTECTED]> wrote:
>>
>>
>> Sorry, the snippet was wrong formatted.
>>
>>
>> pobox77 wrote:
>> >
>> > Hi,
>> >
>> > I would like to create a SqlDatabase either with Username+Password or
>> with
>> > Windows authentification. I am using a radio button in a customize
>> dialog.
>> > If not Windows auth. is selected, the user can enter a username and a
>> > password.
>> > How should I set the SqlDatabase component to do it? I mean, if
Windows
>> > auth. the User="SQLUser" should not be used.
>> >
>> > Snippet:
>> >
>> >       <Component Id="CreateDB" DiskId="1"
>> > Guid="????????-????-????-????-????????????">
>> >         <sql:SqlDatabase Id="MyDb" Server="[SQLSERVER]"
>> > Database="[SQLDBNAME]" CreateOnInstall="yes" ConfirmOverwrite="yes"
>> > DropOnReinstall="no" DropOnUninstall="no" User="SQLUser">
>> >           <sql:SqlScript Id="CreateTablesSqlScript"
>> ContinueOnError="no"
>> > ExecuteOnInstall="yes" ExecuteOnReinstall="no" Sequence="002"
>> > BinaryKey="CreateTablesBin" User="SQLUser" />
>> >         </sql:SqlDatabase>
>> >       </Component>
>> >
>> >     <Feature Id="SqlDb" Title="Create Database"
Description="Installing
>> > database. Please ensure that the SQL Server is running on the target
>> > server." AllowAdvertise="yes" TypicalDefault="install"
Display="expand"
>> > Level="1">
>> >       <ComponentRef Id="CreateDB" />
>> >     </Feature>
>> >
>> >
>> > Thanks in advance,
>> > Peter
>> >
>>
>> --
>> View this message in context:
>>
http://www.nabble.com/Creating-SqlDatabase-with-without-Windows-Authentification-tf3394305.html#a9449474
>> Sent from the wix-users mailing list archive at Nabble.com.
>>
>>
>>
-------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>> your
>> opinions on IT & business topics through brief surveys-and earn cash
>>
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> WiX-users mailing list
>> WiX-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/wix-users
>>
>
>
-------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys-and earn cash
>
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> WiX-users mailing list
> WiX-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/wix-users
>
>

--
View this message in context:
http://www.nabble.com/Creating-SqlDatabase-with-without-Windows-Authentification-tf3394305.html#a9453722
Sent from the wix-users mailing list archive at Nabble.com.


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users

Reply via email to