SQL Gateway Connection via ODBC to MariaDB connection failed
Hi
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 :
Connection failed.
SQLState: () NativeError: [2002] Message:
And another way try to testing with this command
d $SYSTEM.SQLGateway.TestConnection("MariaDBodbc")
I got the error message look like this :
INST01:USER>d $SYSTEM.SQLGateway.TestConnection("MariaDBodbc")
Connection failed
SQLState: () NativeError: [2002] Message:
INST01:USER>zw %objlasterror
%objlasterror="0 "_$lb($lb(5023," SQLState: () NativeError: [2002] 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: [2002] Message: - */
And SQL Gateway Connection configulation file path is /inst01/iris/mgr/irisodbc.ini
[MariaDBodbc]
Description=MariaDB server
Driver=/inst01/iris/bin/libmaodbc.so
SERVER=xx.xx.xx.xx
USER=user
PASSWORD=pwd
DATABASE=trydb
PORT=3306
Anyone has experience with this?
Product version: IRIS 2021.1
$ZV: IRIS for UNIX (Red Hat Enterprise Linux for x86-64) 2021.1 (Build 215_0_21450U) Tue Feb 22 2022 16:27:06 EST