Welcome to the wonderful world of the Windows Installer. <smile/> I just appreciate that you're trying to narrow down the work yourself. Lets me respond with very short messages that help you in the right direction. I rarely have time to diagnose the whole thing myself.
-----Original Message----- From: Chad Miles [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2008 10:26 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Patching SQL Database with script Just now Rob, and it looks like a flip flop. During Install: MSI (s) (CC:18) [12:58:31:859]: Component: sql_db_remote_sql; Installed: Absent; Request: Local; Action: Local MSI (s) (CC:18) [12:58:31:859]: Component: sql_db_remote_sql_patch; Installed: Absent; Request: Local; Action: Null MSI (s) (CC:18) [12:58:31:859]: Component: sql_sqlscript; Installed: Absent; Request: Local; Action: Local During Patch: MSI (s) (CC:28) [13:05:22:945]: Component: sql_db_remote_sql; Installed: Local; Request: Local; Action: Local MSI (s) (CC:28) [13:05:22:945]: Component: sql_db_remote_sql_patch;Installed: Local; Request: Null; Action: Null MSI (s) (CC:28) [13:05:22:945]: Component: sql_sqlscript; Installed: Local; Request: Local; Action: Local I guess I have a lead now, but that's kinda crazy based on my conditioning. Feeling a little noobish... : o On Wed, Nov 26, 2008 at 1:17 PM, cemiles <[EMAIL PROTECTED]> wrote: > > I'm gonna go out on a limb here. Since it looks like some sort of error in > the binary table, is it required to declare a second binary pointing to the > same script to use in the patch component? Is there some clashing since > I'm > using SqlScript1 in both components? > > <Binary Id="SqlScript1" > SourceFile="../../../../../folder/bin/sql/MyScript_MSSQL.sql"/> > > > cemiles wrote: > > > > 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-tp713025p1581976.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 ------------------------------------------------------------------------- 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