Exporting data from SAP server to SQL server

[Former Member]

Hi ABAPers,

I have created a program to fetch the data from SAP server to SQL server, this program is working fine when executing directly ....

But if i am scheduling this program i am not getting the data from SAP server to SQL server and in SM37 its just going some than 7500 sec.....(and also job not finished...)

problem is in the SAP server, program is just finding the DSN, Server, Database, IP address......

How to solve this issue,

please suggest....

is there any function module to connect the SQL server's IP address from SAP server.

Regards

Prasad.

[HermannGahm]

Hi Prasad,

check this note:

Number 323151

Short text Several DB connections with Native SQL

and the referenced notes inside (e.g. 829706)

hth,

Hermann