That just shows the ConfigureSql action had no work to do. Did you look at the install states of your Components to see if things that you think are being installed are actually being installed?
-----Original Message----- From: cemiles [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2008 10:09 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Patching SQL Database with script Ok, the best (or most promising) place where it might be griping is here... MSI (s) (CC:28) [13:05:24:039]: Doing action: ConfigureSql Action 13:05:24: ConfigureSql. Configuring SQL Server Action start 13:05:24: ConfigureSql. MSI (s) (CC:28) [13:05:24:039]: Transforming table Binary. MSI (s) (CC:28) [13:05:24:039]: Transforming table Binary. MSI (s) (CC:28) [13:05:24:039]: Note: 1: 2262 2: Binary 3: -2147287038 MSI (s) (CC:80) [13:05:24:055]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI74.tmp, Entrypoint: ConfigureSql MSI (s) (CC!EC) [13:05:24:133]: Transforming table Binary. MSI (s) (CC!EC) [13:05:24:133]: Transforming table Binary. MSI (s) (CC!EC) [13:05:24:133]: Note: 1: 2262 2: Binary 3: -2147287038 Action ended 13:05:24: ConfigureSql. Return value 1. Rob Mensching-2 wrote: > > A verbose log file should show you everything that is being done and from > there you can figure out why things were skipped. > > -----Original Message----- > From: cemiles [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 26, 2008 09:31 > To: wix-users@lists.sourceforge.net > Subject: Re: [WiX-users] Patching SQL Database with script > > > It's not in a CA I authored, but in ExecuteSqlStrings I thought. > > Here's what I'm working with. msi installs fine and does what i want, > then > the msp succeeds (even if i set the patch script's continueonerror="no"). > that's the part that's baffling, like it won't even fire off even thought > i've conditioned it to. > > (PRECONDITION: NT login is manually created for us on the remote server > prior to running install/patch). > > <util:User Id="sysadmin" Name="[DBUSERNAME]" Password="[DBUSERPW]"/> > > <DirectoryRef Id="INSTALLDIR"> > <Component Id="sql_db_remote_sql" Guid="" SharedDllRefCount="yes"> > <Condition>SQLTYPE=3 AND NOT PATCH</Condition> > <sql:SqlDatabase Id="sqltest_remote_sql" Database="[DBNAME]" > CreateOnInstall="yes" CreateOnReinstall="no" DropOnUninstall="no" > Server="[DBSERVERNAME]" User="sysadmin" > > <sql:SqlString Id="executesqlstring_grantlogin_sql" Sequence="1" > ExecuteOnInstall="yes" SQL="USE [DBNAME] EXEC sp_grantlogin > '[PROMPTEDDOMAIN]\[PROMPTEDUSER]'" ContinueOnError="no" /> > <sql:SqlString Id="executesqlstring_defaultdb_sql" Sequence="2" > ExecuteOnInstall="yes" SQL="EXEC sp_defaultdb > '[PROMPTEDDOMAIN]\[PROMPTEDUSER]', '[DBNAME]'" ContinueOnError="no" /> > <sql:SqlString Id="executesqlstring_changedb_owner_sql" > Sequence="3" ExecuteOnInstall="yes" SQL="EXEC sp_changedbowner > '[PROMPTEDDOMAIN]\[PROMPTEDUSER]'" ContinueOnError="no" /> > <sql:SqlScript Id="executesqlscript_remote_sql" Sequence="4" > ExecuteOnInstall="yes" ExecuteOnReinstall="yes" BinaryKey="SqlScript1" > ContinueOnError="no" /> > </sql:SqlDatabase> > <CreateFolder></CreateFolder> > </Component> > </DirectoryRef> > <DirectoryRef Id="INSTALLDIR"> > <Component Id="sql_db_remote_sql_patch" Guid="" > SharedDllRefCount="yes"> > <Condition>SQLTYPE=3 AND PATCH</Condition> > <sql:SqlScript Id="executesqlscript_remote_sql_patch" > SqlDb="sqltest_remote_sql" ExecuteOnInstall="yes" ExecuteOnReinstall="yes" > BinaryKey="SqlScript1" ContinueOnError="no" /> > <CreateFolder></CreateFolder> > </Component> > </DirectoryRef> > </Fragment> > </Wix> > > > It's just a little frustrating is all. We're trying to release sometime > soon and I've turned up nothing in my pursuit of an answer. And we have a > little executable program that we 'could' launch after the patch finishes > (and the kicker here is whenever you specify the dbname/dbservername w/i > that exe it runs the scripts fine on the remote machine). > > > Wilson, Phil wrote: >> >> If this code is running in a custom action, it is impersonated or not? >> >> Phil Wilson >> >> -----Original Message----- >> From: cemiles [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, November 26, 2008 9:10 AM >> To: wix-users@lists.sourceforge.net >> Subject: Re: [WiX-users] Patching SQL Database with script >> >> >> Is there an answer for this? I still can't get it to work, and I've seen >> others complain too. I can post my code if someone has time to help out. >> >> >> cemiles wrote: >>> >>> I'm extremely interested in this myself. I know Rob pointed out using >>> sqlscript/string, but I'm getting a failure on my patch as well when >>> doing >>> that stating 'unable to connect to database'. I've read in some forums >>> sql db's don't lend themselves to patches. That could be completely >>> inaccurate (just something I read somewhere). Are you still having the >>> same troubles w/ this too 'elat' ? >>> >>> >>> elat wrote: >>>> >>>> Could you give a little more information? Would these new scripts need >>>> to be included in a separate component other than my SQL Database >>>> component? In my installer I am creating a new database and running a >>>> script CreateTable.sql on the install. This works. For the patch I >>>> changed the CreateTable.sql to AlterTable.sql in my Setup.wxs. I want >>>> to >>>> include new sql scripts in the updated .msi and create a patch that >>>> will >>>> execute the changed sql. Does it need to have a different Binary Key? >>>> When executing the patch.msp I get an option to Change/Repair/Remove. >>>> I've tried both Change and repair, but it seems Change is the option I >>>> want to use since it asks for the SQL credentials. The assemblies are >>>> getting updated but the script is not being run. I'm a little unsure >>>> how >>>> this is all suppose to work. >>>> >>>> <Binary Id="CreateTable" >>>> SourceFile="..\..\SQLScript\MigrateScripts\CreateTable.sql" /> >>>> >>>> <Component Id="SuiteDatabaseComponent" >>>> Guid="d6e96011-3252-4e85-80b5-b1ff64045e88"> >>>> <CreateFolder/> >>>> >>>> <!-- installs database --> >>>> <sql:SqlDatabase Id="db1" >>>> Server="[SQLSERVER]" >>>> Instance="[SQLINSTANCE]" Database="SuiteWix" >>>> CreateOnInstall="yes" >>>> ConfirmOverwrite="yes" >>>> DropOnUninstall="no" User="SQLUser"> >>>> >>>> <!-- define where the database >>>> files are saved --> >>>> <sql:SqlFileSpec Id="mdf" >>>> Name="SuiteWix_Data" >>>> >>>> Filename="[DATABASEDIR]SuiteWiX_Data.mdf" >>>> Size="2MB" >>>> GrowthSize="2MB"/> >>>> <sql:SqlLogFileSpec Id="ldf" >>>> Name="SuiteWix_Log" >>>> >>>> Filename="[DATABASEDIR]SuiteWiX_Log.ldf"/> >>>> >>>> <!-- add reference to database >>>> script bianarieshere --> >>>> <sql:SqlScript Id="CreateTable" >>>> BinaryKey="CreateTable" ExecuteOnInstall="yes"/> >>>> </sql:SqlDatabase> >>>> </Component> >>>> >>>> Eric >>>> >>>> >>>> >>>> -----Original Message----- >>>> From: [EMAIL PROTECTED] >>>> [mailto:[EMAIL PROTECTED] On Behalf Of Rob >>>> Mensching >>>> Sent: Monday, July 28, 2008 10:39 PM >>>> To: General discussion for Windows Installer XML toolset. >>>> Subject: Re: [WiX-users] Patching SQL Database with script >>>> >>>> The SqlScript element (or SqlString if you just want to run a couple >>>> strings). >>>> >>>> -----Original Message----- >>>> From: [EMAIL PROTECTED] >>>> [mailto:[EMAIL PROTECTED] On Behalf Of Eric >>>> Latendresse >>>> Sent: Monday, July 28, 2008 14:59 >>>> To: General discussion for Windows Installer XML toolset. >>>> Subject: [WiX-users] Patching SQL Database with script >>>> >>>> My initial installer creates the SQL database perfectly, but I want to >>>> be able to include new SQL scripts to be run with my patches. Could >>>> someone give me some insight on how to do this? >>>> >>>> >>>> >>>> Eric >>>> >>>> >>>> >>>> >>>> >>>> ------------------------------------------------------------------------ >>>> - >>>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>>> challenge >>>> Build the coolest Linux based applications with Moblin SDK & win great >>>> prizes >>>> Grand prize is a trip for two to an Open Source event anywhere in the >>>> world >>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>>> _______________________________________________ >>>> WiX-users mailing list >>>> WiX-users@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/wix-users >>>> >>>> >>>> ------------------------------------------------------------------------ >>>> - >>>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>>> challenge >>>> Build the coolest Linux based applications with Moblin SDK & win great >>>> prizes >>>> Grand prize is a trip for two to an Open Source event anywhere in the >>>> world >>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>>> _______________________________________________ >>>> WiX-users mailing list >>>> WiX-users@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/wix-users >>>> >>>> >>>> ------------------------------------------------------------------------- >>>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>>> challenge >>>> Build the coolest Linux based applications with Moblin SDK & win great >>>> prizes >>>> Grand prize is a trip for two to an Open Source event anywhere in the >>>> world >>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>>> _______________________________________________ >>>> 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/Patching-SQL-Database-with-script-tp713025p1581637.html >> Sent from the wix-users mailing list archive at Nabble.com. >> >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >> Build the coolest Linux based applications with Moblin SDK & win great >> prizes >> Grand prize is a trip for two to an Open Source event anywhere in the >> world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> WiX-users mailing list >> WiX-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/wix-users >> >> >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >> Build the coolest Linux based applications with Moblin SDK & win great >> prizes >> Grand prize is a trip for two to an Open Source event anywhere in the >> world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> 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/Patching-SQL-Database-with-script-tp713025p1581751.html > Sent from the wix-users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the > world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the > world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > 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/Patching-SQL-Database-with-script-tp713025p1581950.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
