Not as far as we can tell. Like I mentioned if I provide the same server name in uppercase it works. I am using SQL Server 2005 SP2 and Wix version 3.0.4318.0.
-----Original Message----- From: Michael Osmond [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2008 3:31 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Help with SqlDatabase element... Vidya, The error number translates to 80004005 which I think is an Access Denied type error. I must say I am not sure why changing the case of the server name would cause this. Is anything else different when you get this error, other than case? Michael -----Original Message----- From: Vidya Kukke [mailto:[EMAIL PROTECTED] Sent: Friday, 17 October 2008 8:25 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Help with SqlDatabase element... This is the error string reported in the log. Error -2147467259: failed to create SQL database: <mydbname>, error detail: unknown error. Thanks Vidya -----Original Message----- From: Michael Osmond [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2008 3:18 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Help with SqlDatabase element... Vidya, I have never seen this, server names should be case insensitive What is the actual error text thrown by WIX? Michael -----Original Message----- From: Vidya Kukke [mailto:[EMAIL PROTECTED] Sent: Friday, 17 October 2008 7:13 AM To: General discussion for Windows Installer XML toolset. Cc: Douglas Gong Subject: Re: [WiX-users] Help with SqlDatabase element... Did'nt see any response for this? Anyone seen a similar error? -----Original Message----- From: Vidya Kukke [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2008 3:09 PM To: General discussion for Windows Installer XML toolset. Cc: Douglas Gong Subject: Re: [WiX-users] Help with SqlDatabase element... Sorry for not being clear. What I meant was the value I provide for my public property [SQLSERVER] i.e, If the value of [SQLSERVER] is set to 'myservername' then the Wix throws an error during DB creation. However if [SQLSERVER] is set to 'MYSERVERNAME' the DB is created successfully. Where myservername is a valid name of my machine. Can't see how the casing on the value matters/affecting SqlDatabase creation. Is this clearer? Regards, Vidya -----Original Message----- From: Ian Elliott (Excell Data Corporation) [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2008 2:07 PM To: General discussion for Windows Installer XML toolset. Cc: Douglas Gong Subject: Re: [WiX-users] Help with SqlDatabase element... If you specify the property name with lower case letters then it is no longer a public property and can't be passed in via command line. I assume you are passing these values in so that might explain what is going on. There is some good info here on properties: http://bonemanblog.blogspot.com/2005/06/all-about-properties.html -----Original Message----- From: Vidya Kukke [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2008 1:58 PM To: wix-users@lists.sourceforge.net Cc: Douglas Gong Subject: [WiX-users] Help with SqlDatabase element... Hi, I am using Wix 3.0.4318.0 for creating a Database. The code snippet is as follows:- <sql:SqlDatabase Id="CreateConfigDB" Database="[DBNAME]" Server="[SQLSERVER]" Instance="[NAMEDINSTANCE]" CreateOnInstall='yes' ConfirmOverwrite='yes' ContinueOnError='no'> I noticed that when I specify the sqlserver name in lowercase I get an error during DB Creation. The message is "Unspecified error" thrown by Wix. Providing the same server name in Uppercase works without any issues. What is the cause for this? Should I be adding/taking care of this? Thanks in advance. Regards, Vidya ------------------------------------------------------------------------ - 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 ------------------------------------------------------------------------ - 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 ------------------------------------------------------------------------ - 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 ------------------------------------------------------------------------- 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
