topic Re: From SAP to a SQL Server Database in Application Development and Automation Discussions

From SAP to a SQL Server Database

Former Member — Fri, 04 Mar 2005 15:12:46 GMT

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.

Re: From SAP to a SQL Server Database

christian_wohlfahrt — Fri, 04 Mar 2005 17:19:17 GMT

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

Re: From SAP to a SQL Server Database

Former Member — Mon, 07 Mar 2005 19:09:41 GMT

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.

Re: From SAP to a SQL Server Database

andreas_mann3 — Tue, 08 Mar 2005 08:00:16 GMT

Rashid,

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

Andreas

Re: From SAP to a SQL Server Database

Former Member — Tue, 08 Mar 2005 09:09:51 GMT

Hi,

Take a look at See if it helps.

Regards

Re: From SAP to a SQL Server Database

Former Member — Tue, 08 Mar 2005 21:53:20 GMT

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.

Re: From SAP to a SQL Server Database

Former Member — Tue, 26 Apr 2005 04:29:33 GMT

Re: From SAP to a SQL Server Database

Former Member — Tue, 26 Apr 2005 04:33:34 GMT

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

please guide,

Thanx.

Re: From SAP to a SQL Server Database

Former Member — Tue, 26 Apr 2005 13:44:13 GMT

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.