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-tp1642658p1642658.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
