This is the first problem I had with the new oracle adapter pack.
From the error message, it is quite obvious right. But I was quite sure that I have provided the right user name and password.
I found the answer here, the user name / password may be case sensitive. After providing the user name and password with the appropriate case sensitivity, it is working now. hopla ;)
Monday, April 28, 2008
Microsoft.ServiceModel.Channels.Common.ConnectionException: ORA-1017: invalid username/password; logon denied
Subscribe to:
Post Comments (Atom)
4 comments:
THANK YOU! We had the exact same issue, only the exception message read slightly differently:
Error occurred while browsing the LOB system. Adapter Message: ORA-1017: invalid username/password; logon denied
You already said this in your post, but I would emphasize again that the username is case-sensitive AS WELL AS the password. In our case, the username had to be ALL CAPS (matches the Oracle schema that was created around that user). This is counter-intuitive because all the clients I have ever used to connect to Oracle 9i and Oracle 10.2g have been case-insensitive on both username and password. This bizarre Visual Studio error message had put a huge roadblock in our dev efforts for using the WCF Oracle adapter. But your post has saved our bacon. Thank you for making my day! -- Robert Lewis
Hey Robert, glad that it helped ;)
Great Post!
Same problem, same solution.
If you think about the message...it's truth, the username is wrong.
Thank you.
I feel SQL and other aspects really help to find more and more aspects and solutions to complex IT problems and looking for more solutions.
SQL Server Load Soap API