How to set {$MYSQL.DSN} macro without creating a odbc.init file in Zabbix server?

[solaireofastora]

How to set {$MYSQL.DSN} tamplate macro without creating a odbc.init file in Zabbix server?

I've tried something like this, but it does not work

"Driver=/usr/lib64/libmyodbc8a.so;Server=192.168.0.10;Port=3306"

Is there a way to set {$MYSQL.DSN} without creating a /etc/odbc.init file in linux server? I don't want to use the data source name.

[cyber]

Add "Database=<your db name>" to that line...

Syntax:
"Driver=<DriverName or </path/to/driver.so>;Database=<DB NAME>;Server=<IP/DNS>;Port=3306"

If fields "Username" and "Password" are set
String: "UID=<user>;PWD=<password>" will be added to "connection string" automatically

Examples:

"Driver=MariaDB;Database=zabbix;Server={HOST.CONN};Port=3306"
"Driver=/usr/lib64/libmaodbc.so;Database=zabbix;Server={HOST.CONN};Port=3306"
"Driver=MariaDB;Database=zabbix;Server={HOST.CONN};Port=3306;UID=<username>;PWD=<pass>"

[solaireofastora]

"Driver=<DriverName or </path/to/driver.so>;Database=<DB NAME>;Server=<IP/DNS>;Port=3306" does not work.

I got the error in zabbix: Cannot connect to ODBC DSN: [SQL_ERROR]:[HY090][0][[unixODBC][Driver Manager]Invalid string or buffer length]