Skip to Content
0
Former Member
Jul 11, 2008 at 02:52 PM

Unable to connect from SAP BI 7.0 to external AS/400 database

297 Views

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