[Mono-list] Connecting to Oracle as SYSDBA

[Daniel Morgan]

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
>