Conntect to MySQL Database

814 Views

Hello SAP Community!

I need a connection to a MySQL database from SAP. I read the post from Gudmundur Karlsson, How can I connect to MySQL external database, and followed his description. He said that we should use MSSQL as DBMS, but I am not able to connect to a MySQL Database.

Firstly, I installed the MySQL Connector/ODBC 5.1.6 and set up an ODBC connection called TEST on the Application Server in the control panel -> administrative tools. The connection test was successfully.

After that I made an entry in the transaction DBCO with the following details, based on the post from Gudmundur Karlsson:

Connection Name: MYSQL

DBMS: MSS

Username and Password from the MySQL Database.

Connection info: MSSQL_DSN=TEST

Then I wrote the following report to test the connection:

PARAMETERS: p_dbs TYPE dbcon-con_name DEFAULT 'MYSQL'.

EXEC SQL.

CONNECT TO :p_dbs

ENDEXEC.

WRITE: sy-subrc.

The sy-subrc is always 4.

Has anybody an explanation, how I can connect to a MySQL Database.

Kind regards!