[Mono-list] Connecting to Oracle as SYSDBA

[Jörg Rosenkranz]

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 <monodanmorg at yahoo.com>

> 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 <marc.puts at realtimesolutions.nl> wrote:
>
> > From: Marc Puts <marc.puts at realtimesolutions.nl>
> > Subject: [Mono-list] Connecting to Oracle as SYSDBA
> > To: mono-list at lists.ximian.com
> > 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  -  Mono-list at lists.ximian.com
> > http://lists.ximian.com/mailman/listinfo/mono-list
> >
>
>
>
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20101129/45bdce9f/attachment-0001.html