The only thing I can see from decoding that error is that you are trying to insert Null values into a column. Has the schema changed? I converted the error code (-2147217900) into hex (FFFFFFFF80040E14), removed the sign (80040E14) and got lots of Googles about Null insert issues (see http://www.google.co.uk/search?hl=en&q=80040E14&btnG=Google+Search&meta=)
>From the results it does seem schema related. Perhaps someone saw the upgrade as a good time to make the changes they needed? Ryan -----Original Message----- From: Amy Rosewater [mailto:[EMAIL PROTECTED] Sent: 22 September 2008 22:14 To: General discussion for Windows Installer XML toolset. Subject: [WiX-users] SQL Server 2008 Hi All, I have an install that has been working well for months against SQL Server 2005. We recently upgraded one of our test servers to SQL Server 2008 and now the Wix Component to create my database no longer executes correctly. The error number I receive is 26201. I have searched for other reports of this error being encountered and it appears to potentially be related to the use of the SqlFileSpec and SqlLogFileSpec elements in my wix xml. >From my log: Error 26201. Error -2147217900: failed to create SQL database: iVantage50, error detail: CREATE DATABASE failed. Some file names listed could not be created. Check related errors.. >From my wix xml: <sql:SqlDatabase Id="IVantageDatabase" Server="[SQLSERVER]" Database="[DATABASENAME]" User="InstallationSqlUser" CreateOnInstall="yes" DropOnUninstall="yes"> <sql:SqlFileSpec Id="IVantageDatabaseFile" Filename="[DataDirectory][DATABASENAME][DATABASEFILEEXT]" Name="[DATABASENAME]" /> <sql:SqlLogFileSpec Id="IVantageDatabaseLogFile" Filename="[DataDirectory][DATABASENAME][DATABASELOGFILENAMEEXT][DATABASE LOGFILEEXT]" Name="[DATABASENAME][DATABASELOGFILENAMEEXT]" /> Any ideas why this would stop working for SQL Server 2008? Thanks in advance for your help. Amy Rosewater SPECTRUM Human Resource Systems Corporation 707 17th Street Suite 3800 Denver CO, 80202 303.592.3403 [EMAIL PROTECTED] ------------------------------------------------------------------------- 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 No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database: 270.7.0/1683 - Release Date: 22/09/2008 06:39 ------------------------------------------------------------------------- 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
