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
