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
