Forgive me for shameless advertising. You might want to try ODBC_Execute immediate CA from http://msiext.codeplex.com or ODBCExecute wix extension, neither should have this problem. There're BULK INSERT constructs for problems like yours + we've implemented a minimal parser in the next release (current source code) so you can have delimiters, SQL-server specific constructs like :r, etc.
dB. @ dblock.org Moscow|Geneva|Seattle|New York -----Original Message----- From: Rob Mensching [mailto:r...@robmensching.com] Sent: Tuesday, February 02, 2010 10:31 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] [WIX-Users] Problem while running big sql script file Uhh, yeah, I don't think we've ever tested a script that big. That is E_OUTOFMEMORY and we have some known "non-ideal" memory usage issues in the SqlExtension today. You're likely hitting that. Hopefully, you can split the script into smaller chunks. On Tue, Feb 2, 2010 at 5:50 AM, akash bhatia <911ak...@gmail.com> wrote: > Hi, > > I am using the WiX 3.0 and using the *WixSqlExtension *for creating the DB > and running a script file on this DB. > > While installing the product .... i am getting the error as: > > InstallSqlData: Error 0x8007000e: failed to read from stream > InstallSqlData: Error 0x8007000e: failed to read SqlScripts table > > One thing i want to share with you guys is that the size of my sql script > file is around 352 MB. > > is it not recommended to use such a big script file ? > > -- > Cheers, > Akash > > ------------------------------------------------------------------------------ > The Planet: dedicated and managed hosting, cloud storage, colocation > Stay online with enterprise data centers and the best network in the > business > Choose flexible plans and management services without long-term contracts > Personal 24x7 support from experience hosting pros just a phone call away. > http://p.sf.net/sfu/theplanet-com > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > -- virtually, Rob Mensching - http://RobMensching.com LLC ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
