Well, somewhere along the line, you're generating a command line to SqlPackage.exe when you're deploying using a dacpac (all but one of my products deploy in this manner). A dacpac is generated from a sqlproj project. It's basically a renamed ZIP file with some SQL, some metadata, etc. There's generally also an assembly, and a publish.xml file. All of these are passed to SqlPackage.exe which makes the database deployment. Since WiX has no support for this deployment, there will be some custom tables and one or more custom actions to run the show.
It looks like the filename of the publish.xml file is being appended as a suffix to the connection string either in validation or as the target connection string to SqlPackage.exe. Without seeing your code, that's the only way I can figure you getting that error. -- John Merryweather Cooper Build & Install Engineer - ESA Jack Henry & Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -----Original Message----- From: Harold Wood (H10 Capital) [mailto:v-wow...@microsoft.com] Sent: Monday, March 10, 2014 4:57 PM To: General discussion about the WiX toolset. Subject: Re: [WiX-users] database not installing WIX and dacpac -----Original Message----- From: John Cooper [mailto:jocoo...@jackhenry.com] Sent: Monday, March 10, 2014 12:40 PM To: General discussion about the WiX toolset. Subject: Re: [WiX-users] database not installing What is the SQL database deployment technology you are using? VsdbCmd, SqlPackage, WiX, or other? -- John Merryweather Cooper Build & Install Engineer - ESA Jack Henry & Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -----Original Message----- From: Harold Wood (H10 Capital) [mailto:v-wow...@microsoft.com] Sent: Monday, March 10, 2014 2:36 PM To: General discussion about the WiX toolset. Subject: Re: [WiX-users] database not installing I'm getting a weird error when I run my installer. *** Error parsing connection string: Could not find a part of the path '... WiX.publish.xml'.. The installer runs great on my dev box but hoses with that error when run on the test environment. Does anyone know how to get around this? Thanks Woody ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
