LineVoltageHalogen wrote:

> Greetings All, I am writing a small test app in C# .Net 2.0 that needs
> to connect to an Oracle 10g database. I need to use Microsoft's data
> provide System.Data.OracleClient to connect to the database and I need
> to connect as "SYS." There seems to be no provision for connecting as
> "SYSDBA"? Am I missing something or is this a limiation of the
> provider? Any help would be greatly appreciated.

Frans Bouma [C# MVP] wrote:
> LineVoltageHalogen wrote:
>
> > Greetings All, I am writing a small test app in C# .Net 2.0 that needs
> > to connect to an Oracle 10g database. I need to use Microsoft's data
> > provide System.Data.OracleClient to connect to the database and I need
> > to connect as "SYS." There seems to be no provision for connecting as
> > "SYSDBA"? Am I missing something or is this a limiation of the
> > provider? Any help would be greatly appreciated.
>
> Correct, there's no connection string option to specify if the
> connection should be made as SYSDBA or DBA privileges.
>
> Why do you need SYSDBA access btw? You could login as SYSTEM, which
> has most privileges as well.
>
> FB
>
> --
> ------------------------------------------------------------------------
> Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
> LLBLGen Pro website: http://www.llblgen.com
> My .NET blog: http://weblogs.asp.net/fbouma
> Microsoft MVP (C#)
> ------------------------------------------------------------------------