Skip to Content

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Oct 05, 2009 at 01:59 PM

    Hi,

    Check if this thread can help

    [Secondary database connections;

    Regards,

    Vikranth

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2009 at 09:05 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.