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

Question

I am trying 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's SQLSetConnectAttr failed

I'm using Delphi, but answers in any language are welcome.

Clarification: I am able to connect as a normal user. I run into trouble when I try to connect AS SYSDBA.

score 4 · Accepted Answer · answered Oct 10 '08 at 03:37

4

You can't connect as SYSDBA using standard System.Data.OracleClient, as stated by this post : http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2245591&SiteID=1.

You can do that using ODP .NET (Oracle Data Provider for .NET), or other third parties library. If you're planning to build serious Oracle Application on .NET, I suggest you at least look at ODP.NET

answered Oct 10 '08 at 03:37

Salamander2007

6,294
8
32
26

We moved from ODP.Net to the excellent third party library - DevArt (formerly CoreLAB)'s OraDirect.Net. They let you connect as SYSDBA or SYSOPER (http://www.devart.com/oranet/docs/CoreLab.Oracle~CoreLab.Oracle.OracleConnectionStringBuilder~ConnectMode.html) :o) – Andrew Oct 10 '08 at 12:17

score 2 · Answer 2 · edited May 22 '20 at 08:24

2

Posting the answer here as this is the top result when looking for an answer for DBA PRIVILEGE connection string

Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ORCL))); User ID=sys; Password=syspassword; DBA PRIVILEGE=SYSDBA

edited May 22 '20 at 08:24

高鵬翔

1,997
2
8
21

answered May 22 '20 at 07:14

ListenToBob

21
2

I approved the improvement. Thank you! – ListenToBob May 22 '20 at 08:25

score 1 · Answer 3 · answered Oct 07 '08 at 16:49

1

I'm not sure what you mean by connecting as a SYS, but there here is a link to sweet repository of connection strings. I hope you can find your answer there.

answered Oct 07 '08 at 16:49

Matt R

2,577
5
30
46

as sys = with the user name of "sys". From sql plus it would be SYS AS SYSDBA. – JosephStyons Oct 07 '08 at 16:53

score 1 · Answer 4 · answered Mar 29 '22 at 21:49

1

using Oracle.ManagedDataAccess, the connection string for sys as sysdba is:

Data Source=myOracleDB;User Id=SYS;Password=SYS;DBA Privilege=SYSDBA;

ref

answered Mar 29 '22 at 21:49

M.Hassan

10,282
5
65
84

score 0 · Answer 5 · answered Oct 07 '08 at 16:56

Oracle Connection string sample

You must have your Oracle SID defined in your TNSNames file. Which is the data source.

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

If you are using Visual Studios you can add a data source in the Sever Explore and it will give you the connection string.

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

5 Answers5

Linked