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
