Ok, how can I implement it in a better way ... Thanks in advanced! tom
cemiles wrote: > > Oh, I think I know what you're saying now. And I believe the answer is > you > do need 2 components in order to do so, or so I've read and done. > > On Mon, Dec 15, 2008 at 9:10 AM, tgoffice <tgoff...@web.de> wrote: > >> >> Sorry, no this is a missunterstanding (my bad english >> ... :confused:) >> >> How can I differ between a SqlDatabase with and without integrated >> security, >> withoud creating to components with nearly the same content (only the >> User >> differs but I have to duplicate all sql scripts) >> >> >> >> >> cemiles wrote: >> > >> > Sorry, and that tag is incorrect for the RBG. >> > >> > Should read <RadioButtonGroup Property="ISINTEGRATEDSECURITY"> >> > >> > >> > >> > cemiles wrote: >> >> >> >> You could set up a radiobuttongroup control and tie that condition >> >> property to it. >> >> >> >> So, something like this would be the short version for 1 property >> >> DATABASEUSER: >> >> >> >> <Fragment> >> >> <UI> >> >> <Dialog Id="DBUserServerDlg" Width="370" Height="270" >> >> Title="!(loc.DBUserServerDlg_Title)"> >> >> <Control Id="RadioButtons" Type="RadioButtonGroup" X="35" >> Y="85" >> >> Width="301" Height="66" Property="ISINTEGRATEDSECURITY"> >> >> <RadioButtonGroup Property="SQLTYPE"> >> >> <RadioButton Text="!(loc.DBUserServerDlg_DBRadio1_Text)" >> >> X="0" Y="0" Width="300" Height="15" Value="1" /> >> >> </RadioButtonGroup> >> >> </Control> >> >> <Control Type="Edit" Width="172" Height="15" X="155" Y="151" >> >> Id="DatabaseUserText" Property="DATABASEUSER"> >> >> <Condition Action="show">ISINTEGRATEDSECURITY=0</Condition> >> >> <Condition Action="hide>ISINTEGRATEDSECURITY=1</Condition> >> >> </Control> >> >> <Control Type="Text" Width="112" Height="10" X="35" Y="154" >> >> Id="DatabaseUser" Transparent="yes" NoPrefix="yes" >> >> Text="!(loc.DBUserServerDlg_DatabaseUser)"> >> >> <Condition Action="show">ISINTEGRATEDSECURITY=0</Condition> >> >> <Condition Action="hide">ISINTEGRATEDSECURITY=1</Condition> >> >> </Control> >> >> </Dialog> >> >> </UI> >> >> </Fragment> >> >> >> >> Is this what you're looking for or am I mis-reading? >> >> >> >> >> >> tgoffice wrote: >> >>> >> >>> Hello, >> >>> >> >>> what is the most elegant (common way) to distingwhish between sql >> >>> connection with integrated security and with user name/password. >> >>> >> >>> I have a GUI to enter user database server, instance name, user name, >> >>> password ... to connect to an database. If user name and password are >> >>> not provided integrated securits should be used. >> >>> I have a property "ISINTEGRATEDSECURITY" to differ between the >> >>> installation of two different components. >> >>> (very error pron and with duplicate code, very ugly) >> >>> >> >>> WIX code to differ between both authentications >> >>> >> >>> <util:User Id="DatabaseUser" Name="[DATABASEUSER]" >> >>> Password="[DATABASEPASSWORD]"/> >> >>> >> >>> <Component Directory="SERVERDIR" Id="comp_db_create" DiskId="1" >> >>> KeyPath="yes" Guid="3B3DCDB3-BCA8-4F71-8269-AF2F36EFF80A"> >> >>> <Condition>ISINTEGRATEDSECURITY = 0</Condition> >> >>> <sql:SqlDatabase Id="ProcessEngineDatabase" >> ConfirmOverwrite="yes" >> >>> CreateOnInstall="yes" Server="[DATABASESERVER]" >> >>> Instance="[DATABASEINSTANCE]" Database="[DBNAME]" User="DatabaseUser" >> >>> ContinueOnError="no"> >> >>> <sql:SqlScript Id="Upper.S3.DataObjects.drop" BinaryKey="SQL1" >> >>> ExecuteOnInstall="yes" ContinueOnError="no" Sequence="10"/> >> >>> ... >> >>> >> >>> <Component Directory="SERVERDIR" Id="comp_db_create" DiskId="1" >> >>> KeyPath="yes" Guid="3B3DCDB3-BCA8-4F71-8269-AF2F36EFF80A"> >> >>> <Condition>ISINTEGRATEDSECURITY = 1</Condition> >> >>> <sql:SqlDatabase Id="ProcessEngineDatabase" >> ConfirmOverwrite="yes" >> >>> CreateOnInstall="yes" Server="[DATABASESERVER]" >> >>> Instance="[DATABASEINSTANCE]" Database="[DBNAME]" >> ContinueOnError="no"> >> >>> <sql:SqlScript Id="Upper.S3.DataObjects.drop" BinaryKey="SQL1" >> >>> ExecuteOnInstall="yes" ContinueOnError="no" Sequence="10"/> >> >>> ... >> >>> >> >>> What is the best way to accomplish this issue. >> >>> >> >>> Thank's >> >>> TG >> >>> >> >> >> >> >> > >> > >> >> -- >> View this message in context: >> http://n2.nabble.com/Distinguish-between-SQL-integrated-security-and-normal-authentication-tp1642658p1658344.html >> Sent from the wix-users mailing list archive at Nabble.com. >> >> >> >> ------------------------------------------------------------------------------ >> SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, >> Nevada. >> The future of the web can't happen without you. Join us at MIX09 to help >> pave the way to the Next Web now. Learn more and register at >> >> http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ >> _______________________________________________ >> WiX-users mailing list >> WiX-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/wix-users >> > > > > -- > Chad E. Miles > Software Engineer, Development > Interactive Intelligence, Inc. > chad.mi...@inin.com > 317.715.8280 Office/Fax > ------------------------------------------------------------------------------ > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, > Nevada. > The future of the web can't happen without you. Join us at MIX09 to help > pave the way to the Next Web now. Learn more and register at > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > -- View this message in context: http://n2.nabble.com/Distinguish-between-SQL-integrated-security-and-normal-authentication-tp1642658p1662667.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
