Connect SQL through ECC 6.0

[Former Member]

Hi All,

I want to connect SQL to R/3 Ecc 6.0.

I have added dbmssslib.dll file on Ecc 6.09 server.

I have configured parameters for DBCO transaction as follows:

DB Connection CON_SQL1

DBMS MSS

User Name sa

DB password /

Conn. info MSSQL_SERVER=tcp:NODE9 MSSQL_DBNAME=NORTHWIND

Connection Limit

Optimum Conns

I am using this connection in report as follows:

DATA sap_web LIKE dbcon-con_name VALUE 'CON_SQL1'.

start-of-selection.

EXEC SQL.

SET CONNECTION :sap_web

ENDEXEC.

if sy-subrc <> 0.

EXEC SQL.

CONNECT TO :sap_web

ENDEXEC.

endif.

IF sy-subrc <> 0.

MESSAGE 'NOT Connected..!!' TYPE 'S'.

LEAVE PROGRAM.

ENDIF.

I am getting short dump as

Short text

Error setting up a secondary database connection

What happened?

Connection to database system not possible with identifier "CON_SQL1".

Please help me for the solution.

Regards,

Sheetal.

[SuhaSaha]

Try using ADBC classes.

Check ADBC_DEMO program for details.

[Former Member]

Hi Sheetal,

Can you help me how to install dbmssslib.dll file on SAP system.

I have searched several forums , can you help me find and install that.

Thanks,

Shobana.K