I don't remember the double arrow being part of the UTF-8 BOM. In any case, it woulnd't surprise me if the SQL CA does not support UTF-8. Try UNICODE or ASCII straight.
-----Original Message----- From: Brian Rogers [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2008 11:27 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Error executing sql scripts with WIX That's a UTF-8 byte order marker. I wonder if a non-BOM UTF-8 text file would work...? ###################################### $_='^#(/||/@[EMAIL PROTECTED]@:^[-['^";@@@\\>])@.". "{)/];)^{";$,+=(++$,);$_.=">&$,";`$_`; -----Original Message----- From: Rob Mensching [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2008 11:20 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Error executing sql scripts with WIX What's that funky character at the beginning of your file? Try resaving the file as ASCII. -----Original Message----- From: Kiran Subhedar (Sogeti) [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2008 23:44 To: wix-users@lists.sourceforge.net Subject: [WiX-users] Error executing sql scripts with WIX Hi, I am getting the below error on installing an msi which uses <Sql:SqlScript /> to execute a set of stored procedures . I don't think there is anything wrong with the procedures. Error: Action 23:34:21: ExecuteSqlStrings. Executing SQL Strings ExecuteSqlStrings: Error 0x80040e14: failed to execute SQL string, error: Incorrect syntax near '»'., SQL key: SqlScript1 SQL string: ----------------------------------------------------------------------- -- Create all Stored Procedures The stored procedures are of the form as below. /****** Object: StoredProcedure [dbo].[Gen_mtblEulaResponse_DelByPK] Script Date: 11/08/2007 15:13:40 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Gen_mtblEulaResponse_DelByPK]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N' CREATE PROCEDURE [dbo].[Gen_mtblEulaResponse_DelByPK] ( @ResponseGUID VARCHAR(32) ) AS SET NOCOUNT ON DELETE FROM [mtblEulaResponse] WHERE [ResponseGUID] = @ResponseGUID ' END GO Kindly help! Thanks, Kiran ------------------------------------------------------------------------- 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
