Dear All,
We are attempting to setup a connection from an SAP BI 7.0 system running on a MS Windows/SQLServer to an external AS/400 based DB2 database. We have made the entries in the DBCON table as follows:
Connection name: AS400
DBMS: DB4
Username: <username>
Password: <password>
Conn info.: AS4_HOST=<hostname>;AS4_DB_LIBRARY=<library_name>
Permanent: checked
Connection Limit: 5
Optimum Conns: 5
Note: Username and AS4_DB_LIBRARY are set to the same value
When I attempt a test connection by running /SE38->ADBC_TEST_CONNECTION, I get the following error in the workprocess log file:
B create_con (con_name=AS400)
B Loading DB library 'D:\usr\sap\DBI\DVEBMGS00\exe\dbdb4slib.dll' ...
M *** ERROR => DlLoadLib: LoadLibrary(D:\usr\sap\DBI\DVEBMGS00\exe\dbdb4slib.dll) Error 193 [dlnt.c 237]
B *** ERROR => Couldn't load library 'D:\usr\sap\DBI\DVEBMGS00\exe\dbdb4slib.dll'
[dbcon.c 4731]
B ***LOG BYG=> could not load library for database connection AS400 [dbds#1 @ 1035] [dbds 1035 ]
B ***LOG BZY=> unexpected return code 8192 calling DBACDS [dbacds#2 @ 1471] [dbacds 1471 ]
Note:
1. Environment details:
SAP BI 7.0 : Kernel 700 64-bit Unicode, Windows 2003 Standard Server 64-bit, MSSQLServer 2005
SAP Kernel (disp+work) patch = 154
In directory d:\usr\sap\DB1\DVEBMGS00\exe:
Version of dbmsslib.dll = 700 Patch 152
Version of dbdb4slib.dll = 700 Patch 162 (copied here to enable connection to external AS/400 DB2 database)
iSeries Access for Windows loaded on SAP BI Server software version = V5R3M0
Version of file qxdaedrs.dll in C:\windows\system32 folder: Product Version = V5R3M0, FileVersion= 10.0.0.0
Target System: AS/400
DB2 database version = V5R3
Service Pack PTF Number = 07198
Verified job WRKACTJOB SBS(QSYSWRK scheduled and running on the AS/400
Please help us with a resolution to the above connectivity issue.
Thanks,
MG