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 =

openSUSE Build Service is sponsored by