IBM Support

Unable to connect to MySql database using ODBC wrapper with IBM Branded ODBC driver.

Troubleshooting


Problem

Using ODBC wrapper with IBM Branded ODBC driver to select a table on MySql database in Passthru mode returned error SQL0901N.                                                                                     

Symptom

Selecting a MySql table in federated server Passthru mode returned SQL0901N.

SELECT count(*) FROM mySql.mySqltable                                    
SQL0901N  The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed.  (Reason "Can not get server
attribute".)  SQLSTATE=58004   

[{"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data Sources and Wrappers - ODBC","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.7","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

swg21421178