Or someone could contribute the changes to the WiX SQL CA to support those other databases. I for one, have never seen an Oracle box. <smile/>
On Fri, Oct 22, 2010 at 4:45 AM, Christopher Painter < chr...@deploymentengineering.com> wrote: > InstallShield has MSSQL, Oracle and MySQL support. That's as official as > you > are going to get. Anything else for Oracle is going to be roll your own or > punt > and don't have installer do it. > > Christopher Painter, Author of Deployment Engineering Blog > Have a hot tip, know a secret or read a really good thread that deserves > attention? E-Mail Me > > > > ----- Original Message ---- > From: ryan robin <ryanro...@gmail.com> > To: General discussion for Windows Installer XML toolset. > <wix-users@lists.sourceforge.net> > Sent: Fri, October 22, 2010 4:51:08 AM > Subject: Re: [WiX-users] [Wix-user] Run Oracle script > > Hi Bernd, > > Thanks for your help. > The latter solution seems to meet my need. > I'm, howerver, still looking forward to *official* ideas/solutions :) > > Hope that Wix will support Oracle as well as it does to MSSQL Server to > make > our lives easier. > > > Regards, > > Ryan > > On Fri, Oct 22, 2010 at 3:12 PM, Bernd Truckses <bernd.truck...@mpro.de > >wrote: > > > Hi, > > > > I had the same problem. I helped me out with a managed Custom Action. > > The Custom Action is written in C#, uses the Oracle.DataAccess.Client > > namespace, transactions, commands etc ... > > > > Advantages: > > - full control over the DB-process (transaction handling, exception/error > > handling, script preparation/manipulation, parameters, detailed logging, > > etc.) > > > > Disadvantages: > > - .Net Framework has to be installed on target machine first > > - Oracle Data Access Components (ODAC) have to be installed on target > > machine first > > - "exotic solution" outside the regular standard of the MSI > > > > > > Another solution would be to write a Custom Action that starts the > > commandline tool SQL*PLUS in silent mode and passes logon and script > > I think there's even already a built-in Custom Action for that ( > > "LaunchFile" ) - see the notepad example in the Wix-Tutorial (Lesson 3 - > > "Events and Actions", chapter 3.2 "Extra Actions") - > > http://www.tramontana.co.hu/wix/lesson3.php#3.2 > > > > > > Is there an "official" way to do this (apply oracle scripts, pass > > parameters > > to it etc...)? > > That would make me quite more happy then using my Custom Action and so > > including an "exotic solution" in my MSI. > > > > Greets, > > Bernd > > > > > > -----Original Message----- > > From: ryan robin [mailto:ryanro...@gmail.com] > > Sent: Freitag, 22. Oktober 2010 05:36 > > To: wix-users@lists.sourceforge.net > > Subject: [WiX-users] [Wix-user] Run Oracle script > > > > Hi Wixers, > > > > I'm quiet new to Wix. > > > > I have a OracleXE 10g. > > Is there any way to run Oracle script to create/update some tables with > > existing Oracle user (as it should not create new user)? > > > > It seems that Wix doesn't support Oracle at the moment, right? > > > > > > Thanks, > > > > Ryan > > > > > ---------------------------------------------------------------------------- > > -- > > Nokia and AT&T present the 2010 Calling All Innovators-North America > > contest > > Create new apps & games for the Nokia N8 for consumers in U.S. and > Canada > > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in > > marketing > > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > > http://p.sf.net/sfu/nokia-dev2dev > > _______________________________________________ > > WiX-users mailing list > > WiX-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > > > > > > > > ------------------------------------------------------------------------------ > > Nokia and AT&T present the 2010 Calling All Innovators-North America > > contest > > Create new apps & games for the Nokia N8 for consumers in U.S. and > Canada > > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in > > marketing > > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > > http://p.sf.net/sfu/nokia-dev2dev > > _______________________________________________ > > WiX-users mailing list > > WiX-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > ------------------------------------------------------------------------------ > Nokia and AT&T present the 2010 Calling All Innovators-North America > contest > Create new apps & games for the Nokia N8 for consumers in U.S. and Canada > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in > marketing > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > http://p.sf.net/sfu/nokia-dev2dev > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > > > > ------------------------------------------------------------------------------ > Nokia and AT&T present the 2010 Calling All Innovators-North America > contest > Create new apps & games for the Nokia N8 for consumers in U.S. and Canada > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in > marketing > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > http://p.sf.net/sfu/nokia-dev2dev > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > -- virtually, Rob Mensching - http://RobMensching.com LLC ------------------------------------------------------------------------------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
