File sample_odbc.ini of Package mariadb-connector-odbc
#
# System DSN config files are read by unixODBC from
# /etc/unixODBC/odbc.ini
#
# User DSN config files are read from user's home directory
# %{HOME}/.odbc.ini
#
[YOUR_DSN_NAME_HERE]
Description = "DSN Description"
Driver = /usr/lib64/libmaodbc.so
# hostname/ip address of the server, or localhost to use UNIX socket connection
Server =
# connection username, generally not specified in configuration file
User =
# connection password, generally not specified in actual configuration file
Password =
# MariaDB database name
Database =
#Port = 3306
#
# Socket is only used for localhost connections with
# default value that should match MariaDB socket
#Socket = /run/mysql/mysql.sock
# Init Command run on connect
#InitStmt =
# Connection timeout in seconds
#Conn_Timeout =
# ODBC Tracing support
#Trace = On | Off*
#TraceFile = /tmp/trace.path
#No_Prompt =
#Charset =
# SSL Options
#SslKey =
#SslCert =
#SslCa =
#SslCaPath =
#SslCipher =
#SslVerify = On | Off*
#SslFp =
#SslFpList =
#SslCrl =
#SslCrlPath =
# Options is a numeric combination of the following constants
#
#OPT_FLAG_FIELD_LENGTH 1
#OPT_FLAG_FOUND_ROWS 2
#OPT_FLAG_DEBUG 4
#OPT_FLAG_BIG_PACKETS 8
#OPT_FLAG_NO_PROMPT 16
#OPT_FLAG_DYNAMIC_CURSOR 32
#OPT_FLAG_NO_SCHEMA 64
#OPT_FLAG_NO_DEFAULT_CURSOR 128
#OPT_FLAG_NO_LOCALE 256
#OPT_FLAG_PAD_SPACE 512
#OPT_FLAG_FULL_COLUMN_NAMES 1024 /*10*/
#OPT_FLAG_COMPRESSED_PROTO 2048
#OPT_FLAG_IGNORE_SPACE 4096
#OPT_FLAG_NAMED_PIPE 8192
#OPT_FLAG_NO_BIGINT 16384
#OPT_FLAG_NO_CATALOG 32768
#OPT_FLAG_USE_CNF 65536
#OPT_FLAG_SAFE 131072
#OPT_FLAG_NO_TRANSACTIONS 262144
#OPT_FLAG_LOG_QUERY 524288
#OPT_FLAG_NO_CACHE 1048576 /*20*/
#OPT_FLAG_FORWARD_CURSOR 2097152
#OPT_FLAG_AUTO_RECONNECT 4194304
#OPT_FLAG_AUTO_IS_NULL 8388608
#OPT_FLAG_ZERO_DATE_TO_MIN 16777216
#OPT_FLAG_MIN_DATE_TO_ZERO 33554432
#OPT_FLAG_MULTI_STATEMENTS 67108864
#OPT_FLAG_COLUMN_SIZE_S32 134217728
#OPT_FLAG_NO_BINARY_RESULT 268435456
#OPT_FLAG_BIGINT_BIND_STR 536870912
#OPT_FLAG_NO_INFORMATION_SCHEMA 1073741824 /*30*/
#
# To enable forward only cursors, and big packets
# 8 + 2097152 = 2097160
#
#Options =