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 error
Could 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.

Step:1 Install the BizTalk Adapter from below location http://www.oracle.com/technology/software/tech/windows/odpnet/utilsoft.html
and download the ODAC1110720.zip 188 MB Zip file

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\Admin
if 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.

Example :
OracleTest = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Dev_OracleServer)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = Dev_OracleTestDB) ) )
NOw you can try to do a OracleBinding adapter, hope you will win...

Reach me if you still find an issue raj.webjunky@yahoo.com

No comments:

Post a Comment