Export Data to external SQL-Database

Former Member — Fri, 29 Feb 2008 11:08:23 GMT

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.

Re: Export Data to external SQL-Database

Former Member — Mon, 03 Mar 2008 10:40:04 GMT

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