IBM Support

Datastage job accessing MySQL database aborts with the error, Connections to versions of MySQL prior to version 5.0 are not supported.

Troubleshooting


Problem

Datastage job accessing MySQL database aborts with following error despite the fact that the MySQL database version is greater than 5.0: DSR.MetaGeta(GET.DSNINFO)(SQLConnect('MyConnection','prod')) : BCI Error: SQLSTATE=S1000,CODE=0,[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)] [ODBC MySQL Wire Protocol driver]Connections to versions of MySQL prior to version 5.0 are not supported.

Symptom

Datastage job accessing *MySQL* database aborts with following error despite the fact that the *MySQL* database version is great:er than 5.0.

DSR.MetaGeta(GET.DSNINFO)(SQLConnect('ITES_Process','itesprod')) : BCI
Error :
SQLSTATE=S1000,CODE=0,[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)]
[ODBC MySQL Wire Protocol driver]Connections to versions of MySQL prior
to version 5.0 are not supported.

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;8.7;8.5;8.1;8.0;7.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
25 April 2025

UID

swg21454808

Page Feedback