From SAP to a SQL Server Database

[Former Member]

Help...Please

I want to know if I can and how I can connect to a SQL server DB and either put records in a table or retrieve data using ABAP.

Thanks in advance.

[christian_wohlfahrt]

Hi Rashid!

Is it 'your' database, on which SAP is running (probably not) -> use open SQL statements.

It's a second database -> establish a RFC connection to this system and use native SQL.

Regards,

Christian

[Former Member]

Christian,

Thanks for the reply. I was wondering if you had an example code that would allow me to resolve my issue. The SQL DB is not on the same box as SAP. Please advise with as much detail as possible.

Thanks in advance.

[andreas_mann3]

Rashid,

look at this OSS-Note: <b>323151</b>

Andreas

[Former Member]

Hi,

Take a look at See if it helps.

Regards

[Former Member]

Thanks for all of the NICE reply guys. But my issue is not yet resolved.

I have viewed the note. Perhaps it will resolve my issue but I am not sure about what entries and in what format I can enter in the DBCON table. I know Connection Name, User, Pass word, I am not sure about the syntax for Connection Information.

Please help and thanks in advance.

[Former Member]

hi

[Former Member]

hi

i want to know about ABAP programs and SQL server Conncetivity.

please guide,

Thanx.

[Former Member]

Hi,

I still have not gotten to the bottom of this issue. I am currently looking at a program I found on the net. I will post a solution on the site if this works.