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