BizTalk 2009 / Oracle Adapter - Authentication Issue

This is my second post about my current project experience building an integration solution using BizTalk 2009 and the ESB Toolkit 2.0.

This was one of the other issues we encountered using the Oracle Adapter for BizTalk- we were getting Oracle authentication problems/errors from the BizTalk space.

The Oracle User Names must be in upper case UPPERCASE!

We were able to use a successfuly connect using a lower case user name in the Oracle Tools (like Enterprise Manager and SQLPlus) to the Oracle database, but doing this via the Add Adapter metadata in Visual Studio for example using the same lower case user name as we did for Oracle Enterprise Manager and SQL Plus, just gave us errors, specifically this error below:

"ORA-01017: invalid username/password; logon denied."

The only way we could get a successful connection from BizTalk to Oracle using the Oracle adapter was to send through the username in UPPERCASE!

We also encountered some other roadblocks in using the Oracle adapter in BizTalk, things like Oracle driver issues and installation/configuration blues. I will give more info in a coming blog.

 Freddie.