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
