I had looked at the Wix SQL CA source some time ago. Supporting Oracle via ODBC would be a major refactoring job.
If anyone wants to do something productive, develop a whole new set of extensions ala Wix Sql extensions for an Oracle database based on OCI, or extend an infrastructure that's ODBC-based and that was designed to support multiple database vendors (<plug>http://msiext.codeplex.com, which supports SQL Server and Access today</plug>). dB. @ dblock.org Moscow|Geneva|Seattle|New York -----Original Message----- From: Rob Mensching [mailto:r...@robmensching.com] Sent: Wednesday, October 27, 2010 5:09 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] [Wix-user] Run Oracle script 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 ------------------------------------------------------------------------------ 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
