DBA Privilege parameter

DBA Privilege parameter

Postby malsergey » Fri 02 Aug 2013 13:56

Hi,
Does dotConnect for Oracle supports "DBA Privilege" attribute for connection string?
I can't found parameter in connection builder for "DBA Privilege" attribute. Also when I trying to add this parameter to connection string i got error about wrong parameter.

Thanks,
Sergey
malsergey
 
Posts: 1
Joined: Fri 02 Aug 2013 12:10

Re: DBA Privilege parameter

Postby Pinturiccio » Mon 05 Aug 2013 13:44

Yes, dotConnect for Oracle supports connecting with DBA privileges. OracleConnection class has the ConnectMode property, allowing you to connect as SYSDBA or SYSOPER. For more information please refer to http://www.devart.com/dotconnect/oracle/docs/?Devart.Data.Oracle~Devart.Data.Oracle.OracleConnection~ConnectMode.html

You may also specify the value of this property in the connection string. See example below:
Code: Select all
OracleConnecion conn = new OracleConnection("Data source=xxx; user id=xxx; password=xxx; Connect Mode=sysdba;");
Pinturiccio
Devart Team
 
Posts: 2046
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle