We currently use the Microsoft Native .NET Provider for Oracle to do our
connections with...
For one app we really need to be able to connect to the db as a SYSDBA user.

Does anyone know how this can be done using the MS.NET Oracle provider??

Thanks in advance,

I am not sure, as I am not as well versed on the admin side of Oracle. As
long as the SYSDBA user can be named or aliased (for a connection string), I
see no reason why not. I would be wary about where you store this
connstring, however; encryption would be a must for this type of secret.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
"Eidolon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> We currently use the Microsoft Native .NET Provider for Oracle to do our
> connections with...
> For one app we really need to be able to connect to the db as a SYSDBA
user.
>
> Does anyone know how this can be done using the MS.NET Oracle provider??
>
> Thanks in advance,
>
>

Eidolon,

This was a much requested feature in the OLEDB MetaLink groups - and the
company line was always "not available now, but will consider it in future
releases" - and in OLEDB, it never came.

That said, Oracle did add it in the Oracle Data Provider for .Net. I have
no details on the Microsoft Native .NET Provider for Oracle, but here is how
we do it with the Oracle Provider:

/* ********************** */
string cnxtstr = "User Id=SYS;Password=ChangeOnInstall;DBA
Privilege=SYSDBA;Data Source=TNS_ENTRY;";
OracleConnection cnxn = new OracleConnection(cnxtstr);
cnxn.Open();
/* ********************** */


regards
roy fine


"Eidolon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> We currently use the Microsoft Native .NET Provider for Oracle to do our
> connections with...
> For one app we really need to be able to connect to the db as a SYSDBA
user.
>
> Does anyone know how this can be done using the MS.NET Oracle provider??
>
> Thanks in advance,
>
>

Eidolon,

This was a much requested feature in the OLEDB MetaLink groups - and the
company line was always "not available now, but will consider it in future
releases" - and in OLEDB, it never came.

That said, Oracle did add it in the Oracle Data Provider for .Net. I have
no details on the Microsoft Native .NET Provider for Oracle, but here is how
we do it with the Oracle Provider:

/* ********************** */
string cnxtstr = "User Id=SYS;Password=ChangeOnInstall;DBA
Privilege=SYSDBA;Data Source=TNS_ENTRY;";
OracleConnection cnxn = new OracleConnection(cnxtstr);
cnxn.Open();
/* ********************** */

regards
roy fine


"Eidolon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> We currently use the Microsoft Native .NET Provider for Oracle to do our
> connections with...
> For one app we really need to be able to connect to the db as a SYSDBA
user.
>
> Does anyone know how this can be done using the MS.NET Oracle provider??
>
> Thanks in advance,
>
>