如何使用ADO连接字符串以SYS身份连接到Oracle数据库? [英] How can I connect to an Oracle database as SYS using an ADO connection string?

问题描述

我正在尝试:

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

但是我得到了错误:

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

我正在使用Delphi，但欢迎使用任何语言的答案.

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

说明: 我能够以普通用户身份进行连接.尝试连接AS SYSDBA时遇到麻烦.

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

推荐答案

您不能使用标准System.Data.OracleClient作为SYSDBA进行连接，如本文所述:

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.

您可以使用ODP .NET(适用于.NET的Oracle数据提供程序)或其他第三方库来实现.如果您打算在.NET上构建严肃的Oracle应用程序，建议您至少看看ODP.NET

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

这篇关于如何使用ADO连接字符串以SYS身份连接到Oracle数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！