What version of the WiX toolset are you using?
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dhaval Patel
Sent: Monday, December 11, 2006 17:18
To: wix-users@lists.sourceforge.net
Subject: [WiX-users] SQL Script
I am a WIX newbie and I think I have been able to grasp most of the
functionality via trial and error over the last week or so. Nevertheless,
making this SQL script execute has been driving me nuts. I am hoping one of you
experienced folks will be able to help me out. I have attached an image of the
error I receive upon installation and here is the exact text of the error:
"Failed to execute SQL string, error detail: Could not find stored procedure
'C'., SQL Key: Script SQL string: C"
The very first line I had in my SQL script is: CREATE TABLE [dbo].[DataMerge]
Before that I had the line: USE TABLE [MergeFiles] and I received this error -
"Failed to execute SQL string, error detail: Could not find stored procedure
'U'., SQL Key: Script SQL string: U"
It seems that no matter what I put in the my sql script, it errors out on the
first character. Here is my WIX code:
<Component Id ='SqlDatabase' DiskId='1'
Guid='7FE20B5C-FF37-4618-8D6F-3D04BD66E845'>
<SqlDatabase Id='Sql' ContinueOnError='no' CreateOnInstall='yes'
Database='MergeNist'
CreateOnReinstall='no' DropOnUninstall='yes' Instance='[SQLINSTANCE]'
DropOnReinstall='no'
User='MySqlUser' Server='[SQLSERVER]' >
<SqlScript Id='Script' BinaryKey='CreateSql' ExecuteOnInstall='yes' />
</SqlDatabase>
</Component>
<!-- Path to Sql script -->
<Binary Id='CreateSql' SourceFile='Database.sql' />
Let me know if I am missing anything. It'd be thrilling for my entire team if I
get this to work. I am able to create a virtual directory, a Windows user,
install a service, and various assmeblies to the GAC. This is the only thing
that's not working. Thanks in advance!
________________________________
All-in-one security and maintenance for your PC. Get a free 90-day trial!
Learn more!<http://www.windowsonecare.com/purchase/trial.aspx?sc_cid=wl_wlmail>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
