Problem

Error occurs when trying to use Integrator with Oracle database.

ERROR 20160823 16.28.10.15 b2bi_test PE HME Z00 DBTriggerMBC(procengine(DBTriggerMBC))

D:\Axway\shared\local\4edi\lib\dbtest.s4m:66:DATABASE OPEN: failed to load database interface "D:\Axway\B2Bi\Integrator\4edi\dbload\oracle81.db":

Resolution

Example for Windows x86-64 :

1) Download instantclient-basic-windows.x64-12.1.0.2.0

2) Unzip it under C:\OracleClient\instantclient-basic-windows.x64-12.1.0.2.0\instantclient_12_1\

3) Create a file tnsnames.ora
and copy it under C:\OracleClient\instantclient-basic-windows.x64-12.1.0.2.0\instantclient_12_1\network\admin

Example of tnsnames.ora :

B2B_DB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.128.XX.XX)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = B2B_DB)

)

)

4) Edit Integrator environment.dat and set the variables :

- PATH=C:\OracleClient\instantclient-basic-windows.x64-12.1.0.2.0\instantclient_12_1;...

- ORACLE_HOME=C:\OracleClient\instantclient-basic-windows.x64-12.1.0.2.0\instantclient_12_1

- TNS_ADMIN=C:\OracleClient\instantclient-basic-windows.x64-12.1.0.2.0\instantclient_12_1\network\admin

5) Compile the MBC to test the connection

a) launch Integrator "Profile.bat"

b) Create the file "DBconn.s4" with your database access :

DECLARE VARIABLE $c1 STRING;
DATABASE OPEN "b2b221/b2b221@B2B_DB";
#EXEC SQL SELECT
PRINT "**CONNECTION SUCCESSFUL**";
DATABASE CLOSE;

c) compile the test MBC : "c4edi DBconn.s4"

d) copy DBconn.x4 under C:\B2Bi_2.1.0\Share_local\4edi\component

6) Run the MBC "r4edi DBconn.x4"

7) Connection works.
**CONNECTION SUCCESSFUL**