Re: [WiX-users] creatind DB and running SQL script

2009-03-12 Thread akash bhatia
> -Original Message- > From: akash bhatia [mailto:911ak...@gmail.com] > Sent: Thursday, 12 March 2009 10:22 PM > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] creatind DB and running SQL script > > hi Michael, > > thanks for

Re: [WiX-users] creatind DB and running SQL script

2009-03-12 Thread Michael Osmond
. Subject: Re: [WiX-users] creatind DB and running SQL script 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

Re: [WiX-users] creatind DB and running SQL script

2009-03-12 Thread Don Benson
at 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] c

Re: [WiX-users] creatind DB and running SQL script

2009-03-12 Thread akash bhatia
. > > 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 w

Re: [WiX-users] creatind DB and running SQL script

2009-03-11 Thread Michael Osmond
ce 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 g

Re: [WiX-users] creatind DB and running SQL script

2009-03-11 Thread akash bhatia
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 wrote: > Are you getting this error from a verbose installer log? If so, including > the LOGVERBOSE=1 property on the

Re: [WiX-users] creatind DB and running SQL script

2009-03-11 Thread Don Benson
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

Re: [WiX-users] creatind DB and running SQL script

2009-03-11 Thread akash bhatia
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 am not able to locate the cause of this error, can any one help me on this

Re: [WiX-users] creatind DB and running SQL script

2009-03-11 Thread Don Benson
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

[WiX-users] creatind DB and running SQL script

2009-03-11 Thread akash bhatia
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 fa