topic Database mullticonnect with SQL Server 2000 in Application Development and Automation Discussions

Database mullticonnect with SQL Server 2000

Former Member — Thu, 03 Nov 2005 23:23:57 GMT

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

Re: Database mullticonnect with SQL Server 2000

RichHeilman — Thu, 03 Nov 2005 23:43:03 GMT

Have a look at Native SQL.

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

Regards,

Rich Heilman

Re: Database mullticonnect with SQL Server 2000

Former Member — Thu, 03 Nov 2005 23:51:28 GMT

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

Re: Database mullticonnect with SQL Server 2000

RichHeilman — Thu, 03 Nov 2005 23:55:15 GMT

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

Re: Database mullticonnect with SQL Server 2000

RichHeilman — Thu, 03 Nov 2005 23:57:48 GMT

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

Re: Database mullticonnect with SQL Server 2000

RichHeilman — Fri, 04 Nov 2005 00:00:17 GMT

Here is another link.

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

Regards,

RIch Heilman

Re: Database mullticonnect with SQL Server 2000

Former Member — Wed, 16 Nov 2005 23:41:06 GMT

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

Re: Database mullticonnect with SQL Server 2000

RichHeilman — Fri, 25 Nov 2005 01:56:32 GMT

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

Regards,

Rich Heilman