C＃到Oracle 10g - ora-01017：用户名/密码无效;登录被拒绝; [英] C# to Oracle 10g - ora-01017: invalid username/password; logon denied;

问题描述

使用System.Data.OracleCilent，我正在尝试连接到Oracle 10g Express Edition。我的连接字符串如下。

  数据源= xe;用户ID = SYS AS SYSDBA;密码= MYPASS;集成安全性=否; 

但每次我收到以下错误：



ora-01017：用户名/密码无效;登录被拒绝



我尝试过大写&小写凭证，也可以在凭证和每种可能的组合周围加上双引号。请帮我摆脱这个问题。



注意：我可以使用此凭据登录sqlplus&我正在使用VS-2010与.NET Framework 4.0

解决方案

为了以SYSDBA身份登录，请使用以下语法：

< pre lang =text>数据源= xe;用户ID = SYS; DBA权限= SYSDBA;密码= MYPASS

通常SYSDBA权限和SYS用户不应该是使用过，但我认为你故意使用这些特权。

Using System.Data.OracleCilent, I'm trying to connect to Oracle 10g Express Edition. My connection string is as follows.

"Data Source=xe;User Id=SYS AS SYSDBA;Password=MYPASS;Integrated Security=no;"

But every time I'm getting the following error:

ora-01017: invalid username/password; logon denied

I have tried with upper case & lower case credentials, also with putting double quotes around the credentials and every possible combinations. Please help me to get rid of the problem.

NB: I can login to sqlplus with this credentials & I'm using VS - 2010 with .NET Framework 4.0

解决方案

In order to log in as SYSDBA use the following syntax:

Data Source=xe;User Id=SYS;DBA Privilege=SYSDBA;Password=MYPASS

Typically SYSDBA privileges and SYS user shouldn't be used, but I take it you use these privileges on purpose.

这篇关于C＃到Oracle 10g - ora-01017：用户名/密码无效;登录被拒绝;的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！