Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Database mullticonnect with SQL Server 2000

Former Member
0 Kudos

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

7 REPLIES 7

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

0 Kudos

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 ???

0 Kudos

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

0 Kudos

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

0 Kudos

Here is another link.

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

Regards,

RIch Heilman

0 Kudos

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 !!!

0 Kudos

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

Regards,

Rich Heilman