DBIF_DSQL2_CONNECTERR - direct link to DB

[former_member480606]

Hi all,

I'm working on a SAP system in which we want to access directly to our DB (DB4, MSS) by an ABAP program. In transaction DBCO we made the entries for the two DB but when we try to execute the program the system returns the following error:

DBIF_DSQL2_CONNECTERR

does anybody help me?

Our SAP Release is:

SAP ECC 6.0

SAP_BASIS 700 0011 SAPKB70011

SAP_ABA 700 0011 SAPKA70011

PI_BASIS 2005_1_700 0012 SAPKIPYJ7C

ST-PI 2005_1_700 0002 SAPKITLQI2

SAP_BW 700 0012 SAPKW70012

SAP_AP 700 0008 SAPKNA7008

SAP_HR 600 0007 SAPKE60007

SAP_APPL 600 0008 SAPKH60008

....

Operating system: DB400

Release: V5R3

Than you

Gino Bonfiglioli

[Former Member]

Hi Gino,

I don't think the SAP ABAP Application server on iSeries can access remote SQL server through DBCO. Windows DLL doesn't work on AIX or i5/OS environment.

You could install a SAP dialog instance on Windows, then add the DLL files to the kernel directory, and execute the ABAP code with "connect to" only on that instance.

Or consider other programming languages, like Java code through JDBC...

Hope it helps.

Best regards,

Victor

[former_member480606]

Hi Victor,

in order to reach my goal may you explain me better what you mean when you adfirm that I "could install a SAP dialog instance on Windows" ?

If you already made a directly connection between SAP and DB on i5/OS environment may tell me what I have to do.

Thank yoy in advance

Gino

[Former Member]

Hi Gino,

SAP Dialog instance on Windows is attached to your central SAP system on iSeries. It has kernel programs, but not its own database.

The installation guide is available at service.sap.com/instguides. But if the concept is new to you, I would encourage you to hire a consultant...

Best regards,

Victor

[former_member480606]

I solveb my self the proble: there where some corrrupted disks

Gino

[Former Member]

Hello Gino,

It seems that your SAP system is on iSeries. You mention "DB (DB4, MSS)". Does it mean that the remote DB is SQL server? Please clarify.

Best regards,

Victor

[former_member480606]

Hi Victor,

you're right. I mean that we have 2 DB:

The fistr one is the primary DB in which there is SAP:

DB400

V5R3

*LOCAL

sapsrv01

R3SVIDATA

The second one is the remote DB SQL server

Gino