Article View: borland.public.delphi.database.dotnet
Article #68Re: How to connect to Oracle database as sysdba?
From: Marc Rohloff TeamB
Date: Fri, 04 Nov 2005 00:40
Date: Fri, 04 Nov 2005 00:40
17 lines
1608 bytes
1608 bytes
On Thu, 3 Nov 2005 12:37:11 +0500, Ender wrote: > I'm tried to pass: > "Server=mica;Password=xxxxx;User ID=sys;Persist Security Info=true" > > Typical answer is: "System.Data.OracleClient.OracleException: ORA-28009: > connection to sys should be as sysdba or sysoper". > What i need to pass to OracleConnection.Create to connect as sysdba? Try: "User Id=SYS;Password=SYS;DBA Privilege=SYSDBA;Data Source=oracle;" Marc -- Marc Rohloff [TeamB] marc rohloff -at- myrealbox -dot- com
Technical Details
Message-ID:
<1fleglian7anz.dlg@marcrohloff.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<4369bcb3@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 1effe6,3ac4827a84d68481 X-Google-Attributes: gid1effe6,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Marc Rohloff [TeamB]" <"on request"> Subject: Re: How to connect to Oracle database as sysdba? Newsgroups: borland.public.delphi.database.dotnet User-Agent: 40tude_Dialog/2.0.15.1 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit References: <4369bcb3@newsgroups.borland.com> Date: Thu, 3 Nov 2005 19:40:09 -0500 Message-ID: <1fleglian7anz.dlg@marcrohloff.com> X-Face: "huzh55Xi]!ZNni78>a*5+).`SK?<^q2MlHk-C]Z2M9T@\J5ZCB$95Ey+s"XQuhGFA[eutZ :0^AV!Q;t>gE`1-=8d;HZ6~*o1dH<X9\b$!|(}+I'!Xq)@3Op}%0ArW&nf'Qh*EwR X-Antivirus: avast! (VPS 0544-7, 11/03/2005), Outbound message X-Antivirus-Status: Clean NNTP-Posting-Host: 65.31.9.204 X-Trace: newsgroups.borland.com 1131064495 65.31.9.204 (3 Nov 2005 16:34:55 -0700) Lines: 17 X-Authenticated-User: mrohloff Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail