Export Data to external SQL-Database

[Former Member]

Hi all,

i want to export R3-Data to an external SQL-Database.

I define a connection with dbco :

DB-Connection : Test_FH

DBMS : MSS

Connection Info : MSSQL_SERVER=ENTWICKLUNG-02 MSSQL_DBNAME=SigemK MSSQL_SCHEMA=SigemK OBJECTSOURCE=SigemK

The first code is like this

EXEC SQL.

Set Connection 'TEST_FH'

ENDEXEC.

IF SY-SUBRC EQ 0.

EXEC SQL.

Connect TO 'TEST_FH'

ENDEXEC.

IF SY-SUBRC EQ 0.

Else.

Write 'Sorry ...'.

Exit.

EndIf. " Else IF SY-SUBRC EQ 0

Else.

Write 'Erro at Set Connection Test_FH'.

Exit.

EndIf. " IF SY-SUBRC EQ 0

I think the problem is to set the right connection with dbco.

Any ideas ??

Thank all.

[Former Member]

The answer is :

In Connection info don't write the server name, try to put the ip-adress.

Try this

Connection Info : MSSQL_SERVER=192.168.xx.yy MSSQL_DBNAME=SigemK

And ...

... it works