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
CONNECT TO :con
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
6 work_proc: 1
Does anyone know what I need to do to connect to the mySQL database.