Kim,
I looked at your code. Seems to be OK.
Looking at my sql scripts, I have a GO command after each group of
statements. Have you tried adding GO at the end of each of your SQL
commands?
Mike
*Mike Rerick*
*Sr. Software Engineer*
[image: Google Docs] <http://www.iwsinc.com>*ImageWare Systems, Inc.*
9200 S.E. Sunnybrook Blvd., Suite 170
Clackamas, OR 97015
Office: (503) 353-8068 Fax: (503) 353-8065
On Thu, Mar 17, 2011 at 2:20 PM, Michael Osmond <mosm...@baytech.com.au>wrote:
> Hi
>
> -2147467259 converts to 80004005. Try searching on this value.
>
> Michael
>
> -----Original Message-----
> From: kim [mailto:contactme...@gmail.com]
> Sent: Friday, 18 March 2011 7:17 AM
> To: wix-users@lists.sourceforge.net
> Subject: Re: [WiX-users] Error 26201. Error -2147467259: failed to create
> SQL database
>
> Ok, Keeping it simple:
>
> I need to create database and other objects using my msi. Target machine is
> Windows XP SP3 and SQL Server 2008 express edition.
>
> I am using following code to create database but its failing with error
> code: "Error 26201. Error -2147467259: failed to create SQL database " This
> same code works on Windows 7 machine.
>
> Verbose, SQL log and event viewer gives me no more clue than this same
> error
> message.
>
> I am administrator for this machine.
>
> Please let me know how can i debug this issue. Thanks!
>
> Code attached as text file:
>
> http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/file/n6182564/CreateDatabaseScript.txt
> CreateDatabaseScript.txt
>
>
>
> --
> View this message in context:
> http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Error-26201-Error-2147467259-failed-to-create-SQL-database-tp6163225p6182564.html
> Sent from the wix-users mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
> _______________________________________________
> WiX-users mailing list
> WiX-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/wix-users
>
>
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
> _______________________________________________
> WiX-users mailing list
> WiX-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/wix-users
>
The information contained in this transmission contains potentially privileged,
export controlled and/or confidential
information of Imageware Systems, Inc. or its customers or partners. It is
intended only to be read by the person(s)
named above and for no other purpose. You are hereby notified that any
dissemination, distribution, duplication of this
communication or use of its contents for any purpose not authorized expressly
by Imageware Systems, Inc. is strictly
prohibited and could lead to both civil and/or criminal penalties. If you are
not the intended recipient, you are
prohibited to review the contents herein and please contact the sender by reply
e-mail and destroy all copies of the
original message. To reply to our e-mail administrator directly, please send
an e-mail to emailad...@iwsinc.com
------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
