SAP, mySQL and DBCO, seems easy

[Former Member]

Hi,

I have read the solution given from Gudmundur to Pedro Gallardo about connect SAP to mySQL external database.

It seems easy as long I can see, but I canu2019t make it work.

My system: SAP kernel 4.6D, with library dbmssslib.dll installed on my windows appserver

As Gudmundur say:

MSSQL_DSN should work. You should create your DSN using the ODBC Data Source Administrator (in Administrative Tools). Test it and make sure it works to the server and database you need.

Ok, all fine and ready. Created on our appserver using driver ODBC from

mysql-connector-odbc-5.1.5-win32.

Then create the DBCON (in transaction DBCO) with DBMS=MSS and your MySQL User/passwd.

The Conn. info (field CON_ENV) should only contain:

MSSQL_DSN=<your_dsn_name>

Ok. I have tried it using different notations, all of them failed:

dsnname

appserver\dsnname

appserver\dsname

ip_appserver\dsnname

That's all - IF you're using the ODBC DBSL interface on your application server.

Mmm, at this point, I hesitate a little. What do you mean exactly? I think my SAP

have installed DBSL but not ODBC. Is it possible?

If you're using the older OLEDB DBSL (7.00 on sql2005 or older), then you must in addition put MSSQL_DATASOURCE=<your_dsn_name> in the CON_ENV field.

Tested and failed too.

Perhaps itu2019s something missed on my appserver?

[Former Member]

You probably need to install the ODBC drive for MySQL on your system first. The you can verify in the ODBC area whether you can reach the MySQL DB from this system.

J. Haynes

[Former Member]

Thanku2019s for yor answer Joe, but your indications were just done, and the problem persists.

My appserver (and also the client PC), have ODBC for MySql installed. Itu2019s a open software downloaded from http://dev.mysql.com.

Using Windows ODBC Data Source Administrator (in Administrative Tools), the connection was established and tested with no problems between SAP appserv and MySQL. I can reach DB in MySQL system.

I think the problem is that my SAP system never reaches the Windows ODBC connection. If I turn on traces on ODBC Data Source Adm., and test the connection using the same Windows ODBC, a log file is created containing successful connection strings. But if I test my ABAP program, or DBCO configuration, no traces were made.

Thanku2019s again for your interest.

[Former Member]

Hi Milisk,

Have you found a solution to your problem? I have the same problem trying to connect a MySQL Server to SAP. I will appreciate if you could provide me any ideas.

Thanks in advance.