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=, 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
and download the 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

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

No comments:

Post a Comment