This has been discussed extensively...
What is in your .sql script file? Do you have all the batches delimited by
"GO" statements? Use SQL Server Management Studio/Enterprise Manage to load
and save your scripts.
Let us all know if this helps.
On 6/2/07, rajiv ramanan <[EMAIL PROTECTED]> wrote:
Hi all,
I seem to run into a problem while using the <sqlscript> tag. The
following is the code i used and im using wix version 2.05. The script i
am
using is just a sample to create a table. The query is fine. When i used
sqlstring the script is executed and when i used script its not working.
Please help me out with this.
I have tried saving the file in unicode , utf8 utf 16, ansi types also .
but
no results.
<?xml version="1.0" encoding="UTF-8"?>
<Wix xmlns="http://schemas.microsoft.com/wix/2006/01/wi";>
<!--<Wix xmlns:Sql="http://schemas.microsoft.com/wix/SqlExtension";
>-->
<Product Id="02C4F985-DFC1-4e47-B432-6D7771636894" Name='SQL app 1.0'
Language='1033' Codepage='1252'
UpgradeCode='16807415-8849-479d-A351-A3F570C9BF43'
Version='1.0.0' Manufacturer='Cibrax Ltd.'>
<Package Keywords='Installer' Description="SQL App 1.0 Installer"
Id="5FBD2673-09A8-4f13-A3B8-D731D7EE86D0"
Comments='SQL app is a registered trademark of Cibrax Ltd.'
Manufacturer='Cibrax Ltd.' InstallerVersion='100'
Languages='1033' Compressed='yes' SummaryCodepage='1252' />
<Media Id='1' Cabinet='Sample.cab' EmbedCab='yes' />
<!--<Sql:SqlDatabase Id="MySqlDatabase" Database="master"
Server="localhost"
CreateOnInstall="yes"
ContinueOnError="yes"></Sql:SqlDatabase>-->
<Property Id='INSTALLDIR'>C:\Documents and
Settings\Rajiv_Ramanan\Desktop\nbs\</Property>
<Directory Id='TARGETDIR' Name='SourceDir'>
<!--<Directory Id='ProgramFilesFolder' Name='PFiles'>-->
<Directory Id='INSTALLDIR' Name='TestSQL'>
<Component Id="MySqlComponent"
Guid="09AF7CF7-CE63-42b4-BF57-720983F8BBED" KeyPath="yes">
<File Id="one" DiskId="1" Name="one.txt" Source="C:\Documents
and Settings\Rajiv_Ramanan\Desktop\"/>
<CreateFolder></CreateFolder>
<SqlDatabase Instance="sqlinstance" Id="MySqlDatabase"
CreateOnInstall="yes" ContinueOnError="yes" Database="master"
Server="(local)">
<!--<SqlString Id="InsertAdminPerms2" ExecuteOnInstall="yes"
SQL ="create table rajiv3(age int)" />-->
<!--<SqlScript Id="CreateTables" ExecuteOnInstall="yes"
BinaryKey="CreateTablesBin" ContinueOnError="yes" ></SqlScript>-->
</SqlDatabase>
<SqlScript Id="CreateTables" ExecuteOnInstall="yes"
BinaryKey="CreateTablesBin" ContinueOnError="yes" SqlDb="MySqlDatabase"
Sequence="001"></SqlScript>
</Component>
</Directory>
</Directory>
<!--</Directory>-->
<Binary Id="CreateTablesBin" src="C:\Documents and
Settings\Rajiv_Ramanan\Desktop\SQLQuery1.sql"></Binary>
<Feature Id='Complete' Level='1' Description="Full" Title="Full
Installation">
<ComponentRef Id='MySqlComponent' />
</Feature>
</Product>
</Wix>
--
View this message in context:
http://www.nabble.com/Sqlscript-problem-tf3859121.html#a10933027
Sent from the wix-users mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
