rfc with database on different host

[Former Member]

Hi Gurus,

i need to create a RFC TCP/IP connection from my ECC 5.0 system to the database on different host (MS SQL Server 2000).

What i have to put into a definition of this tcp/ip connection in sm59? special registered program? or enough to define a host name of DB? what about sapgateway, communication user there?

I did not find after database instance installation MS SQL client in application server...Will be Ok if i install it now, after database have been created already?

Thank you very much.

[Former Member]

Thank you Marcin, now i understood how it is work.

[Former Member]

Hello,

You don't need to create connection in SM59.

You may call data from external database directly from ABAP

First you must prepare a connection in transaction DBCO

for example:

DB_CONNECTION: database_name
DBMS: MSS for mssql server
USERNAME: user for mssql
DB PASSWORD: You know
CONN INFO: MSSQL_SERVER=ip_or_hostdatabase_instance MSSQL_DBNAME=name_of_database

Next, go to FM or Report and call your external database like this:

exec sql.
connect to: 'database_name'
execute procedure procedure_name( in:y )
disconnect: 'database_name'
endexec.

Regards,

Marcin Gajewski