hi,
problem solved....
thanks all for your valuable inputs..... some problem with SQL only. not
able to figure out what...ll share once figure it out..... moreover i have
made some changes to wxs file as well and tested on other server... its
working fine...
<Component Id ="RUNSQL" Guid ="{my-GUID}">
<util:User Id="MySQLUser" Name ="[SQLUSERNAME]" Password="[SQLPASSWORD]"/>
<sql:SqlDatabase Id ="sqldb" Database ="[DB]" Server ="[SERVER]" User ="
MySQLUser" CreateOnInstall="yes" DropOnUninstall="no" ContinueOnError="no">
<sql:SqlScript Id ="sqlscript1" BinaryKey ="binary_sqlscript1" Sequence ="1"
ExecuteOnInstall ="yes" />
</sql:SqlDatabase>
</Component>
thnks again guys for ur time
Regards,
Akash
On Fri, Mar 13, 2009 at 4:02 AM, Michael Osmond <mosm...@baytech.com.au>wrote:
> Akash,
>
> The problem is unlikely to be WIX or MSI problem as such, so I doubt
> that all the DTF CA work would be worth it. The error is an SQL error,
> and to me appears to be either path or file name related. SQL databases
> are persisted on the file system as a set of files, and it is in
> creating these files that the error occurs.
>
> There may be some information in the SQL Management log.
>
> Your next step should be to create that exact same database manually -
> from an SQL script not the Management Studio gui - and see if you get
> the same error.
>
> Then you need to check what files SQL server is trying to create.
>
> I would also suggest that you try this on another machine and see if you
> get the same error.
>
> Michael
>
> -----Original Message-----
> From: akash bhatia [mailto:911ak...@gmail.com]
> Sent: Thursday, 12 March 2009 10:22 PM
> To: General discussion for Windows Installer XML toolset.
> Subject: Re: [WiX-users] creatind DB and running SQL script
>
> hi Michael,
>
> thanks for your reply.
> that is wat i got from Event viewer and same from verbose log, which is
> as below
>
> CreateDatabase: Error 0x80040e14: failed to create to database:
> Akash_DB,
> error: CREATE DATABASE failed. Some file names listed could not be
> created.
> Check related errors.
> Error 26201. Error -2147217900: failed to create SQL database: Akash_DB,
> error detail: CREATE DATABASE failed. Some file names listed could not
> be created. Check related errors..
> MSI (s) (8C!84) [20:01:24:015]: Product: Akash_WixProject -- Error
> 26201.
> Error -2147217900: failed to create SQL database: Akash_DB, error
> detail:
> CREATE DATABASE failed. Some file names listed could not be created.
> Check related errors..
>
> Action ended 20:01:24: InstallFinalize. Return value 3.
>
> this is exact what i got from verbose
>
> i am not gettin anything to support this... there is no info more than
> this in eventvwr.
>
> Please suggest me any other way to tackle this.
> or else i would be left to last option of using DTF CA for executing
> sqlscripts.
>
> regards,
> Akash
>
>
>
> On Thu, Mar 12, 2009 at 11:04 AM, Michael Osmond
> <mosm...@baytech.com.au>wrote:
>
> > Akash
> >
> > First check the application event log (for a failure error from
> > MSInstaller), the full text of the SQL error is there (I am assuming
> > that the "Check related errors.." means you are reading this error
> > from the error dialog).
> >
> > I suspect there is an MDF or LDF file hanging around in the SQL Server
>
> > default data folders with the same name as the database you are trying
>
> > to create. (Did you detach this database some time but not delete the
>
> > files).
> >
> > Can you try creating the database using a script not the installer.
> > Do you get the same error?
> >
> > Finally, use the SQL Profiler to trace what is going on.
> >
> > Michael
> >
> > -----Original Message-----
> > From: akash bhatia [mailto:911ak...@gmail.com]
> > Sent: Thursday, 12 March 2009 3:16 PM
> > To: General discussion for Windows Installer XML toolset.
> > Subject: Re: [WiX-users] creatind DB and running SQL script
> >
> > the error which i mentioned ... i got it from verbose log itself...
> >
> > Please let me know, if some one can help me on this
> >
> > thnks!
> > Akash
> >
> > On Wed, Mar 11, 2009 at 8:36 PM, Don Benson <dbenso...@gmail.com>
> wrote:
> >
> > > Are you getting this error from a verbose installer log? If so,
> > > including the LOGVERBOSE=1 property on the command line might give
> > more information.
> > >
> > > I would also use SQL Profiler to capture what exactly is getting
> > > sent to the SQL Server. This will probably be enlightening.
> > >
> > > On Wed, Mar 11, 2009 at 10:34 AM, akash bhatia <911ak...@gmail.com>
> > wrote:
> > >
> > > > i am gettin the following error
> > > >
> > > > "failed to create SQL database: AkashDB, error detail: CREATE
> > > > DATABASE failed. Some file names listed could not be created.
> > > > Check related errors.."
> > > >
> > > > this is how i am doing my stuff
> > > >
> > > >
> > > > <Component Id ="RUNSQL" Guid ="my-guid">
> > > >
> > > > <sql:SqlDatabase Id ="sqldb" Database ="[ORGANIZATIONDB]" Server
> > > > ="[SERVER]"
> > > > CreateOnInstall="yes" DropOnUninstall="no" ContinueOnError="no">
> > > >
> > > > <sql:SqlScript Id ="sqlscript2" BinaryKey ="binary_sqlscript2"
> > > > ExecuteOnInstall ="yes" RollbackOnInstall ="yes" ContinueOnError
> > > > ="no"/>
> > > >
> > > > </sql:SqlDatabase>
> > > >
> > > > </Component>
> > > > am not able to locate the cause of this error, can any one help me
>
> > > > on
> > > this
> > > > ?
> > > >
> > > > in sql script i am adding few tables into my database
> > "[ORGANIZATIONDB]"
> > > >
> > > > i am not using "USE [ORGANIZATIONDB]" insode sql script, which i
> > > > guess it takes automatically as its inside sql:SqlDatabase element
> > > >
> > > >
> > > > any help will be appreciated.
> > > >
> > > > thanks!
> > > > Akash
> > > > On Wed, Mar 11, 2009 at 7:06 PM, Don Benson <dbenso...@gmail.com>
> > > wrote:
> > > >
> > > > > I can offer some general suggestions. First, I assume that you
> > > > > will be using osql or sqlcmd to execute the SQL inside of a
> > > > > custom
> >
> > > > > action.
> > > > >
> > > > > If you use sqlcmd, it can process "scripting variables", which
> > > > > are
> >
> > > > > basically on-the-fly text substitions.
> > > > >
> > > > > If you are using osql, I would recommend writing your scripts to
>
> > > > > not reference a database at all. Instead of MyDB.dbo.MyTable,
> > > > > use
> > > > dbo.MyTable.
> > > > > The osql command has a command-line parameter to define the
> > > > > database to use.
> > > > > If you use this parameter inside the custom action, your script
> > > > > will be applied to the correct database.
> > > > >
> > > > > - Don Benson -
> > > > > On Wed, Mar 11, 2009 at 8:09 AM, akash bhatia
> > > > > <911ak...@gmail.com>
> > > > wrote:
> > > > >
> > > > > > hi,
> > > > > >
> > > > > > i have a scenario as described below:
> > > > > > 1. need to capture the DBSERVER on the fly.
> > > > > > 2. need to capture *DBNAME* on the fly.
> > > > > > 3. need to run a script which creates a database named
> > > > > > *DBNAME.*
> >
> > > > > > *4*. need to run another sql script which uses this DBNAME
> > > > > > and run
> > > > some
> > > > > > commands.
> > > > > >
> > > > > > now the problem i am facing: how can i update the DBNAME
> > > > > > propery
> >
> > > > > > on
> > > the
> > > > > fly
> > > > > > in my SQL script ?
> > > > > >
> > > > > > any suggestions will b highly appreciated?
> > > > > >
> > > > > > Regards,
> > > > > > Akash
> > > > > >
> > > > > >
> > > > >
> > > >
> > > --------------------------------------------------------------------
> > > --
> > > --------
> > > > > > Apps built with the Adobe(R) Flex(R) framework and Flex
> > > > > > Builder(TM)
> > > are
> > > > > > powering Web 2.0 with engaging, cross-platform capabilities.
> > > > > > Quickly
> > > > and
> > > > > > easily build your RIAs with Flex Builder, the Eclipse(TM)based
> > > > > development
> > > > > > software that enables intelligent coding and step-through
> > debugging.
> > > > > > Download the free 60 day trial.
> > > > > > http://p.sf.net/sfu/www-adobe-com
> > > > > > _______________________________________________
> > > > > > WiX-users mailing list
> > > > > > WiX-users@lists.sourceforge.net
> > > > > > https://lists.sourceforge.net/lists/listinfo/wix-users
> > > > > >
> > > > >
> > > > >
> > > >
> > > --------------------------------------------------------------------
> > > --
> > > --------
> > > > > Apps built with the Adobe(R) Flex(R) framework and Flex
> > > > > Builder(TM) are powering Web 2.0 with engaging, cross-platform
> > > > > capabilities. Quickly
> > > and
> > > > > easily build your RIAs with Flex Builder, the Eclipse(TM)based
> > > > development
> > > > > software that enables intelligent coding and step-through
> > debugging.
> > > > > Download the free 60 day trial.
> > > > > http://p.sf.net/sfu/www-adobe-com
> > > > > _______________________________________________
> > > > > WiX-users mailing list
> > > > > WiX-users@lists.sourceforge.net
> > > > > https://lists.sourceforge.net/lists/listinfo/wix-users
> > > > >
> > > >
> > > >
> > > --------------------------------------------------------------------
> > > --
> > > --------
> > > > Apps built with the Adobe(R) Flex(R) framework and Flex
> > > > Builder(TM) are powering Web 2.0 with engaging, cross-platform
> capabilities.
> > > > Quickly and easily build your RIAs with Flex Builder, the
> > > > Eclipse(TM)based
> > > development
> > > > software that enables intelligent coding and step-through
> debugging.
> > > > Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
> > > > _______________________________________________
> > > > WiX-users mailing list
> > > > WiX-users@lists.sourceforge.net
> > > > https://lists.sourceforge.net/lists/listinfo/wix-users
> > > >
> > >
> > > --------------------------------------------------------------------
> > > --
> > > -------- Apps built with the Adobe(R) Flex(R) framework and Flex
> > > Builder(TM) are powering Web 2.0 with engaging, cross-platform
> > > capabilities. Quickly and easily build your RIAs with Flex Builder,
> > > the Eclipse(TM)based development software that enables intelligent
> > > coding and step-through debugging.
> > > Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
> > > _______________________________________________
> > > WiX-users mailing list
> > > WiX-users@lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/wix-users
> > >
> > ----------------------------------------------------------------------
> > --
> > ------
> > Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM)
> > are powering Web 2.0 with engaging, cross-platform capabilities.
> > Quickly and easily build your RIAs with Flex Builder, the
> > Eclipse(TM)based development software that enables intelligent coding
> > and step-through debugging.
> > Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
> > _______________________________________________
> > WiX-users mailing list
> > WiX-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/wix-users
> >
> >
> > ----------------------------------------------------------------------
> > -------- Apps built with the Adobe(R) Flex(R) framework and Flex
> > Builder(TM) are powering Web 2.0 with engaging, cross-platform
> > capabilities. Quickly and easily build your RIAs with Flex Builder,
> > the Eclipse(TM)based development software that enables intelligent
> > coding and step-through debugging.
> > Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
> > _______________________________________________
> > WiX-users mailing list
> > WiX-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/wix-users
> >
> ------------------------------------------------------------------------
> ------
> Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
> powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
> easily build your RIAs with Flex Builder, the Eclipse(TM)based
> development software that enables intelligent coding and step-through
> debugging.
> Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
> _______________________________________________
> WiX-users mailing list
> WiX-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/wix-users
>
>
> ------------------------------------------------------------------------------
> Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
> powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
> easily build your RIAs with Flex Builder, the Eclipse(TM)based development
> software that enables intelligent coding and step-through debugging.
> Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
> _______________________________________________
> WiX-users mailing list
> WiX-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/wix-users
>
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
