I haven't peeked at the code, but based on your description, I'll bet that it's closing and reopening connections for each SQL string instead of using connection pooling, etc.
Fire up SQL Profiler and cap a trace of connection events during the installation and that will tell you for sure what exactly is happening on the SQL side. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dana Gutride Sent: Friday, August 15, 2008 06:58 To: Windows Installer XML toolset developer mailing list; General discussion for Windows Installer XML toolset. Subject: [WiX-users] SqlScript Connection Question Quick question regarding the way the WiX sql custom actions. When you specify multiple sql scripts or strings with their associated sequences, does the custom action open a new connection for each string/script executed or does it reuse the connection until it has looped through all of the scripts it's executing? Our reason for asking is we set the database to single user mode when upgrading, run a ton of scripts and then set it back to multi user mode again. Something is coming in two-thirds of the way through a big upgrade and stealing the connection and we are wondering if WiX is doing something with the connections asynchronously. Dana ------------------------------------------------------------------------- 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
