Hi there,
we are having problems with this. Is this supported in direct mode? We are getting an error ORA-28009: connection as SYS should be as SYSDBA or SYSOPER.
Any clues?
Kind regards, Tom
Is connect as SYSDBA supported in direct mode?
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
If you want to connect to a server with User Id=sys, then you have to add the connect mode to your connection string.
OR
The enum OracleConnectMode has the following members:
Default
SysAsm
SysOper
SysDba
Code: Select all
OracleConnection conn = new OracleConnection();
conn.ConnectionString += "Connect Mode=SysDba;";
Code: Select all
OracleConnection conn = new OracleConnection();
conn.ConnectMode = OracleConnectMode.SysDba;
Default
SysAsm
SysOper
SysDba