Hi have a few sql queries in my advanced installer project. These work find on SQL 2008 R2. However on SQL 2012 I done get one of the return properties set.
The log when using SQL 2012 is as follows:
MSI (c) (FC:7C) [12:16:55:897]: Doing action: AI_DATA_SETTER_1
Action 12:16:55: AI_DATA_SETTER_1.
Action start 12:16:55: AI_DATA_SETTER_1.
MSI (c) (FC:7C) [12:16:55:897]: PROPERTY CHANGE: Adding CustomActionData property. Its value is 'CheckDBVersion'.
Action ended 12:16:55: AI_DATA_SETTER_1. Return value 1.
MSI (c) (FC:7C) [12:16:55:897]: Doing action: CheckDBVersion
Action 12:16:55: CheckDBVersion.
Action start 12:16:55: CheckDBVersion.
MSI (c) (FC:50) [12:16:55:898]: Invoking remote custom action. DLL: C:\Users\ADMINI~1\AppData\Local\Temp\2\MSIF86B.tmp, Entrypoint: OnSqlFetch
MSI (c) (FC!B0) [12:16:56:061]: PROPERTY CHANGE: Deleting DB_VERSION_NAME property. Its current value is 'SQL Server'.
MSI (c) (FC!B0) [12:16:56:061]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (c) (FC!B0) [12:16:56:062]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (c) (FC!B0) [12:16:56:062]: PROPERTY CHANGE: Deleting DB_VERSION_SUPPORTED property. Its current value is '0'.
MSI (c) (FC!B0) [12:16:56:062]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (c) (FC!B0) [12:16:56:063]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (c) (FC:50) [12:16:56:065]: Leaked MSIHANDLE (203) of type 790540 for thread 4016
MSI (c) (FC:50) [12:16:56:065]: Leaked MSIHANDLE (197) of type 790541 for thread 4016
Action ended 12:16:56: CheckDBVersion. Return value 1.
MSI (c) (FC:7C) [12:16:56:066]: Doing action: AI_DATA_SETTER_3
Action 12:16:56: AI_DATA_SETTER_3.
Action start 12:16:56: AI_DATA_SETTER_3.
MSI (c) (FC:7C) [12:16:56:066]: PROPERTY CHANGE: Modifying CustomActionData property. Its current value is 'CheckDBVersion'. Its new value: 'CheckDBSchema'.
Action ended 12:16:56: AI_DATA_SETTER_3. Return value 1.
MSI (c) (FC:7C) [12:16:56:066]: Doing action: CheckDBSchema
When using SQL 2008 R2 I get:
MSI (c) (C4:C4) [11:32:50:228]: Doing action: AI_DATA_SETTER_1
Action 11:32:50: AI_DATA_SETTER_1.
Action start 11:32:50: AI_DATA_SETTER_1.
MSI (c) (C4:C4) [11:32:50:228]: PROPERTY CHANGE: Adding CustomActionData property. Its value is 'CheckDBVersion'.
Action ended 11:32:50: AI_DATA_SETTER_1. Return value 1.
MSI (c) (C4:C4) [11:32:50:228]: Doing action: CheckDBVersion
Action 11:32:50: CheckDBVersion.
Action start 11:32:50: CheckDBVersion.
MSI (c) (C4:D0) [11:32:50:229]: Invoking remote custom action. DLL: C:\Users\ADMINI~1\AppData\Local\Temp\MSI424D.tmp, Entrypoint: OnSqlFetch
MSI (c) (C4!F4) [11:32:50:336]: PROPERTY CHANGE: Deleting DB_VERSION_NAME property. Its current value is 'SQL Server'.
MSI (c) (C4!F4) [11:32:50:337]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:337]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:338]: PROPERTY CHANGE: Deleting DB_VERSION_SUPPORTED property. Its current value is '0'.
MSI (c) (C4!F4) [11:32:50:338]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:338]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:387]: PROPERTY CHANGE: Adding DB_VERSION_NAME property. Its value is 'SQL Server 2008 R2 RTM Standard Edition (64-bit)'.
MSI (c) (C4!F4) [11:32:50:387]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:388]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:389]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:389]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:390]: PROPERTY CHANGE: Adding DB_VERSION_SUPPORTED property. Its value is '1'.
MSI (c) (C4:D0) [11:32:50:417]: Leaked MSIHANDLE (203) of type 790540 for thread 3060
MSI (c) (C4:D0) [11:32:50:417]: Leaked MSIHANDLE (197) of type 790541 for thread 3060
Action ended 11:32:50: CheckDBVersion. Return value 1.
MSI (c) (C4:C4) [11:32:50:418]: Doing action: AI_DATA_SETTER_3
Action 11:32:50: AI_DATA_SETTER_3.
Action start 11:32:50: AI_DATA_SETTER_3.
MSI (c) (C4:C4) [11:32:50:418]: PROPERTY CHANGE: Modifying CustomActionData property. Its current value is 'CheckDBVersion'. Its new value: 'CheckDBSchema'.
Action ended 11:32:50: AI_DATA_SETTER_3. Return value 1.
MSI (c) (C4:C4) [11:32:50:418]: Doing action: CheckDBSchema
As you can see with 2008 I get the variable set. But not with 2012. Should I be doing something different with 2012?
Thanks.
-Arun
FOLLOW US
Get the latest news in Application Packaging