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 ;)
THANK YOU! We had the exact same issue, only the exception message read slightly differently:
ReplyDeleteError 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 ;)
ReplyDeleteGreat Post!
ReplyDeleteSame 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.
ReplyDeleteSQL Server Load Soap API