oracle.dataaccess无效的用户名/密码 [英] oracle.dataaccess invalid username/password

问题描述

我有一个asp.net Web应用程序，其中使用oracle.DataAccess组件连接到Oracle DB.我的DBA创建了一个新帐户，当我尝试在toad中使用该帐户登录时，它的工作原理很好，但是当我在SERVER A中的连接字符串中传递值时，它给了我无效的用户名/密码.我仔细检查了凭据，它们是正确的.然后，我将整个网站复制到新的SERVER B中，当我尝试时，便能够登录到oracle DB.我对所发生的事情非常困惑.有任何想法吗?可以在我的服务器上启用任何跟踪吗?

I am having a asp.net web application in which I am connecting to a Oracle DB using oracle.DataAccess component. My DBA created a new account and when I try to login with that account in toad, it simply worked fine but when I am passing the values in connection string in SERVER A it is giving me invalid username/password. I double checked the credentials and they are correct. Then I copied the entire website into a new SERVER B and when i tried, I am able to login to the oracle DB. I am very much confused about whats happening. Any Ideas? Is it possible to enable any trace on my servers?

推荐答案

您使用哪个版本(Oracle DB和Oracle.DataAccess)?

Which version (Oracle DB and Oracle.DataAccess) do you use?

在Oracle 11中，密码区分大小写(默认情况下)，在以前的版本中则不区分大小写.因此，低于11的Oracle.DataAccess版本可能无法正确处理区分大小写的密码.

In Oracle 11 passwords are case-sensitive (by default), in prior version it was not. Thus Oracle.DataAccess version earlier than 11 may have problems dealing properly with case sensitive passwords.

这篇关于oracle.dataaccess无效的用户名/密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！