Skip to Content
0
Former Member
Aug 09, 2010 at 12:17 PM

Connect SQL through ECC 6.0

35 Views

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.