I'm working on a ABAP program connecting to a Linux based MySQL server for data retrieval/update.
I've followed the suggestion provided by Gudmundur in the thread: http://scn.sap.com/thread/1310696
I've created a ODBC DSN connection and tested OK in Administrative Tools.
However, the connection is failed when using parameter "MSSQL_DSN=<DSN>" in the DBCO setting.
I've tried again by creating a DSN connection to another MSSQL server but it failed as well.
As I've completed a program connecting to a MSSQL server before, I doubt that it fails because my SAP system do not access any Windows level ODBC settings.
May I know if any prerequisities I missed?
Thank you very much.