Bugs item #1511706, was opened at 2006-06-24 00:27 Message generated for change (Comment added) made by derekc You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=642714&aid=1511706&group_id=105970
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None >Priority: 8 Submitted By: Christian Ullrich (chrullrich) >Assigned to: Derek (derekc) Summary: ODBCDriver fails in merge modules Initial Comment: This applies to both current WiX weeklies: 3.0.1821.0 and 2.0.4221.0. The ODBCDriver element works fine in Products, but it fails in merge Modules, because it generates undecorated foreign keys for all three such fields in the ODBCDriver table. I have attached an example. The nested ODBCDriver element causes the following error messages: candle -nologo odbc_minimal.wxs light -nologo -out odbc_minimal.msm odbc_minimal.wixobj .\odbc_minimal.wxs(15) : error LGHT0204 : ICE03: Not a valid foreign key; Table: ODBCDriver, Column: Component_, Key(s): ansi_driver .\odbc_minimal.wxs(15) : error LGHT0204 : ICE03: Not a valid foreign key; Table: ODBCDriver, Column: File_, Key(s): ansi_driver .\odbc_minimal.wxs(15) : error LGHT0204 : ICE03: Not a valid foreign key; Table: ODBCDriver, Column: File_Setup, Key(s): ansi_driver Moving the ODBCDriver element outside of the File has the same result. In contrast, a Shortcut is handled correctly, with fully decorated foreign keys generated. I have not been able to find a resource that says that ODBC drivers cannot be registered in merge modules. The foreign-key columns of the ODBCDriver table are not marked as "modularize" in tables.xml. I'm sorry I cannot verify if that fixes the bug, but right now, building WiX is beyond me. ---------------------------------------------------------------------- >Comment By: Derek (derekc) Date: 2006-06-24 15:58 Message: Logged In: YES user_id=518766 Wow, that's a good bug. It's been in there since the WiX toolset was created (goes to show how many people use the ODBC functionality). ---------------------------------------------------------------------- Comment By: Christian Ullrich (chrullrich) Date: 2006-06-24 15:12 Message: Logged In: YES user_id=10395 It turns out building WiX is surprisingly painless, except for downloading gigabytes of prerequisites. Adding the attributes to the column declarations in tables.xml appears to indeed fix the problem. Linking the merge module works, merging it into an .msi works, and that package installs and works. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=642714&aid=1511706&group_id=105970 Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ WiX-devs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/wix-devs
