How to connect to Oracle database as SYS using ADO connection string?

Question

I am trying to do this:

Provider=MSDASQL.1;Persist Security Info=False;User ID=sys;Password=pwd;Initial Catalog=DATABASE;Data Source=OdbcDataSource;DBA Privilege=SYSDBA

But I get the error:

[Microsoft][ODBC Driver Manager] Driver SQLSetConnectAttr failed

I use Delphi, but answers in any language are welcome.

Explanation: I can connect as a regular user. I encountered difficulties when trying to connect AS SYSDBA.

Answer 1

You cannot connect as SYSDBA using the standard System.Data.OracleClient, as indicated in this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2245591&SiteID=1 .

ODP.NET(Oracle Data Provider for.NET) . Oracle .NET, ODP.NET

Answer 2

, , SYS, . , .

Answer 3

Oracle

SID Oracle, TNSNames. .

Data Source=oracl;User Id=userID;Password=password;Integrated Security=no

Visual Studios, Sever Explore, .