Database mullticonnect with SQL Server 2000

[Former Member]

Hi ¡!!

I’m working in a proyect, that consist in send data to other db server that is not on the r3 database server,

both database server are running on SQL Server 2000.

The version of sap is 46b.

S.O. Windows 2000 SERVER

Any ideas are welcome!

Thanks !!

Message was edited by: Noemi Huerta

Message was edited by: Noemi Huerta

[RichHeilman]

Have a look at Native SQL.

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/frameset.htm

Regards,

Rich Heilman

[Former Member]

HI Rich !!!

i worked with Native SQL, and this does the map between

the native sql, and the database server on R3, but i don't know if i can use this and send information to other database server that is independent of sap r3.

Have you worked with something similar ???

[RichHeilman]

You can definitely use it to connect to other databases. I have tried working with it in the past, but did not get it working. SAP told me that the reason was that I was running on an AS400, and that you need a windows app server in order to get it working. If you search this forum, you should see some posts which will help you.

Regards,

Rich Heilman

[RichHeilman]

Here is one that might help you along.

Please remember to award points for any helpful answers that you might recieve. Thanks.

Regards,

Rich Heilman

[RichHeilman]

Here is another link.

http://www.sap4.com/contentid-146.html

Regards,

RIch Heilman

[Former Member]

Hi Rich !!!!

Thanks by your suggestions,

i follow the notes, but i couldn't connect now the system send a message:

<i>ABAP/4 Program ZMX_BC_IN_CONEXION .

Source ZMX_BC_IN_CONEXION Line 38.

Error Code DBIF_DSQL2_OBJ_UNKNOWN.

Module $Id: //bas/46D/src/krn/runt/abexsql.c#8 $ SAP.

Function ExecuteCall Line 806.

Table does not exist in database.. </i>

The table exist, but i don't know where is the problem !!!

[RichHeilman]

Are you sure that the table name is spelled correctly, and that it exists in the DB in question?

Regards,

Rich Heilman