One commercial option for this problem is Devart dotConnect for Oracle: http://www.devart.com/dotconnect/oracle/ This works on Mono too.
I'm not affiliated with this company, only a customer. Joerg. 2010/11/23 Daniel Morgan <[email protected]> > The API of System.Data.OracleClient nor its connection string provide a way > for you to connect as sysdba. This is a known limitation. If you were > using .net on windows, I would suggest for you to use odp.net from oracle. > However, odp.net does not work on mono. > > DBA Privilege is not a valid connection string parameter for > System.Data.OracleClient. > > There is data direct's oracle provider which may work on mono and it may > have the ability to connect as sysdba. > > > --- On Mon, 11/22/10, Marc Puts <[email protected]> wrote: > > > From: Marc Puts <[email protected]> > > Subject: [Mono-list] Connecting to Oracle as SYSDBA > > To: [email protected] > > Date: Monday, November 22, 2010, 4:35 PM > > Hi list, > > > > I'm trying to create a privileged connection to an Oracle > > database using > > the following line: > > > > using System.Data.OracleClient; > > ... > > var con = new System.Data.OracleConnection("Data > > Source=192.168.5.1/TMP;User ID=sys;Password=xxxxxx;DBA > > Privilege=SYSDBA"); > > > > > > However, this line throws an ArgumentException: "Connection > > parameter > > not supported: 'DBA PRIVILEGE'". > > > > I've also tried creating a connection string using the > > OracleConnectionStringBuilder class, but it also doesn't > > seem to feature > > privileged connections. > > > > Connecting as a normal user (without the DBA Privilege > > part) works with > > no problems. > > > > I'm using Mono 2.6.7 on Ubuntu 10.10. > > > > Any pointers on how to do this? > > Thanks! > > > > Regards, > > Marc > > _______________________________________________ > > Mono-list maillist - [email protected] > > http://lists.ximian.com/mailman/listinfo/mono-list > > > > > > _______________________________________________ > Mono-list maillist - [email protected] > http://lists.ximian.com/mailman/listinfo/mono-list >
_______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
