IBM Support

Specified driver could not be loaded due to system error 1114

Troubleshooting


Problem

Updating an existing SQL map in Sterling B2B Integrator Map Editor, ODBC File Properties, Data Source selected, clicks Update and receives error

Symptom

Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (Oracle in OraClient11g_home1, C:\app\xxxxxx\product\11.2.0\client2\BIN\SQORA32.DLL).;

Cause

The DSN specified on the map is not configured with a 32 bit driver.
The map editor uses a 32 bit driver in order to connect to the database and bring in the table(s) and column(s) data to be used in the map, and for compiling the map.

Environment

Map Editor, using a 64 bit driver for the DSN specified in map, or using a 3rd party driver

Diagnosing The Problem

Verify that the DSN used in the map was created specifying a 32 bit driver

Resolving The Problem

Launch the odbcad32.exe from the Windows/SysWOW64/ folder and ensure that you have the current driver for the database version you are connecting to, specified in the Data Source that is being used in the map

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Mapping and Translation","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"5.2;5.2.1;5.2.2;5.2.3;5.2.4;5.2.5;5.2.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
04 January 2019

UID

swg22002701

Page Feedback