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
