Thanks ryan.
Enabling Wix log with attribute /L*v helped -
I forgot to remove "CREATE DATABASE" command from my script which was
already taken care by wix's sql extension ;).
Cheers
Pankaj
On Dec 5, 2007 6:17 PM, Ryan O'Neill <[EMAIL PROTECTED]> wrote:
> When I run into weird SQL errors like that it is usually down to
> context, for example the language of the user accessing the db is
> different between your admin user (that you test with) and your WiX
> user. More likely, I think you are probably using different users and
> you have a permissions problem. Run SQL Server Profiler to see what is
> actually happening and under what user when you try to install.
>
> Pankaj Bhatia wrote:
> > Hello
> >
> > I am new to wix and currently trying to install my sql schema using
> > wix's SQLExtension. here is my code -
> >
> > <Component Id="SlaDB"
> > Guid="15129d56-f448-4e22-82c5-0035af0099cd">
> > <sql:SqlDatabase Id="ABCDatabase" Database="ABCDb"
> > Server="localhost\SQLEXPRESS"
> > CreateOnInstall="yes" DropOnUninstall="yes"
> > ContinueOnError="yes">
> > <sql:SqlScript Id="CreateTables" ExecuteOnInstall="yes"
> > ExecuteOnUninstall="no" BinaryKey="CreateSLADbBin"/>
> > </sql:SqlDatabase>
> > <CreateFolder/>
> > </Component>
> >
> > My SQL script runs successfully if run directly with SQL express but
> > while installing thru wix I simply receive
> > "msierrSQLFailedCreateDatabase" error. Could anyone tell what is wrong.
> > I don't have the localization file for SQL extension( though I wrote
> > 10 basic variables). It would be great if someone could provide me
> > that loc in US-en.
> >
> > Thanks in advance.
> > Pankaj
> > ------------------------------------------------------------------------
> >
> >
> -------------------------------------------------------------------------
> > SF.Net email is sponsored by: The Future of Linux Business White Paper
> > from Novell. From the desktop to the data center, Linux is going
> > mainstream. Let it simplify your IT future.
> > http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > 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 Free Edition.
> > Version: 7.5.503 / Virus Database: 269.16.13/1170 - Release Date:
> 12/4/2007 10:52
> >
>
>
--
-Pankaj Bhatia
European Microsoft Innovation Center (EMIC)
Ritterstr. 23. Aachen 52072.
Germany
Off: (+49) 241 99784 501
Cell: (+49) 160 5892 705
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
