SQL Gateway Connection via ODBC to MariaDB connection failed
I try to create an ODBC connection to MariaDB using SQL Gateway Connection. It works when testing with isql command at OS level but in the SQL Gateway Connection test is failed as this message :
SQLState: () NativeError:  Message:
And another way try to testing with this command
I got the error message look like this :
INST01:USER>d $SYSTEM.SQLGateway.TestConnection("MariaDBodbc") Connection failed SQLState: () NativeError:  Message: INST01:USER>zw %objlasterror %objlasterror="0 "_$lb($lb(5023," SQLState: () NativeError:  Message: "_$c(13,10),,,,,,,,$lb(,"USER",$lb("e^TestODBCConnection+28^%apiGTW^1","e^TestConnection+28^%apiGTW^1","e^zTestConnection+1^%SYSTEM.SQLGateway.1^1","d^^^0"))))/* ERROR #5023: Remote Gateway Error: SQLState: () NativeError:  Message: - */
And SQL Gateway Connection configulation file path is /inst01/iris/mgr/irisodbc.ini
Anyone has experience with this?