Skip to Content
0
Former Member
May 23, 2007 at 09:16 PM

Access DB2 on AS400 from Windows based SAP platform thru ABAP

22 Views

Hello All,

I've gone thru all the posting and various SAP notes but still not able to connect to the external DB2 system on AS400 using ABAP. Here is the error I'm getting:

**********************************************************************************

ShrtText

Error setting up a secondary database connection.

What happened?

It is impossible to connect to a database system with the identifier

"CON_NAME".

**********************************************************************************

Here is the entry in DBCON :

DB Connection: CON_NAME

DBS: DB4

User Name: USERNAME

DB password: PASSWORD

Connection info.: AS4_HOST=HOST;AS4_DB_LIBRARY=LIBRARYNAME;AS4_QAQQINILIB=FILENAME;

Permanent: X

Connection Limit: 0

Optimum Conns: 0

I'm getting the above error at the time of establishing the connection:

EXEC SQL.

SET CONNECTION :CON_NAME

ENDEXEC.

The database server job is running on the remote DB server. Also I'm able to connect to the DB on the application server using Client Access and ODBC.

I would appreciate any help in this regard.

Cheers!

Sajal