Skip to Content
0
Oct 05, 2009 at 01:51 PM

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

223 Views

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