Friday, 16 July 2010

BizTalk Adapter Pack - Working with Oracled Database Adapter

I am trying to connect to ORACLE database directly using BizTalk Adapter Pack and when I try click Connect at Add generated schema It was throwing the below errorCould not load file or assembly 'Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

You can fix the above issue by installing the Oracle client ( correct version) and bit of Configuration at your Box.

Note: Different version of Oracle Client will remains to throw same error at BizTalk side

Step2: Once you installed the Oracle Client then find out the TNSNAMES.ORA file from below location

\app\product\11.1.0\client_1\Network\Adminif you don not find them no worries.. you can copy the file from \Samples Folder and modify the File with your Server IP/Name and Port number and Database Name.