Is it possible to read a mySQL database from an ABAP report?

[former_member498918]

We have some information stored in a mySQL database which is now required on ABAP reports.

Is it possible to read the mySQL database from an ABAP report? I'm still a bit confused on that.

So far I have setup DBCO with information about the mySQL server using MMS as the DBS because mySQL was not an option. I have made sure we have the latest dbmssslib.dll installed.

When I try to run the following code

EXEC SQL.

CONNECT TO :con

ENDEXEC.

I get error: SQL Server does not exist or access denied.

Then I have tried to connect using the function CHECK_CONNECTION_SDB.

I get the following messages in the return table:

1 OS-AppServ:Windows NT

2 dbmcli_neg: no_client_software

3 dbmrfc_c_neg: no_client_software

4 dbmrfc_s_neg: no_client_software

5 sql_neg

6 work_proc: 1

Does anyone know what I need to do to connect to the mySQL database.

Thank you

Karen

[Former Member]

Hi,

Check if this thread can help

[;

Regards,

Vikranth

[former_member498918]

Thank you for your reply. I've gone through all the documentation you sent and much more and I'm still not sure what the problem is.

One thing that concerns me is that this all relates to MS SQL server and I'm trying to link to a mySQL database. Is this even possible?

Some posts talk about changing Oracle settings and having J2EE installed. Is this necessary to connect to a mySQL database via ABAP?

Which user should I enter into DBCO? Is it the mySQL server user or a SAP user? Does the person in charge of the mySQL database need to add any permissions for SAP to access the database or is that done by the user in DBCO?

Does anyone have any more advice?

Thank you

Karen

Also, does anyone know what the messages from the CHECK_CONNECTION_SDB function mean

1 OS-AppServ:Windows NT

2 dbmcli_neg: no_client_software

3 dbmrfc_c_neg: no_client_software

4 dbmrfc_s_neg: no_client_software

5 sql_neg

6 work_proc: 1

Edited by: Karen Dean on Oct 6, 2009 4:44 AM

[Former Member]

Hi,

In program we need to do the code as below...remaining connection to database should be done by basis

and not handeled in program.

EXEC SQL.

SELECT POSNR FROM REVENUE

WHERE VBELN = '123'

ENDEXEC.

Regards,

Arun.

[former_member498918]

It's getting connected to the mySQL database which is a problem not the coding. So far I haven't managed to connect from dbacockpit.

I get error -- ERROR SQL error 1-: [DBNETLIB][ConnectionOpen (Connect()).]SQL Serverdoes not exist or access denied.

Do I need to post this message somewhere else? How can I do that now? Do I need to re-post it?

Thank you

Karen