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 <[email protected]> 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 <[email protected]> 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 > > [email protected] > > 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/wix-users
