Zabbix Documentation 4.2

4.2
English
Recent Changes

Sidebar

manual:config:items:itemtypes:odbc_checks:unixodbc_mssql

Table of Contents

Installation

  • Red Hat Enterprise Linux/CentOS:
# yum -y install freetds unixODBC
  • Debian/Ubuntu:

Please refer to FreeTDS user guide to download necessary database driver for the corresponding platform.

For some additional information please refer to: installing unixODBC.

Configuration

ODBC configuration is done by editing the odbcinst.ini and odbc.ini files. These configuration files can be found in /etc folder. The file odbcinst.ini may be missing and in this case it is necessary to create it manually.

Please consider the following examples:

odbcinst.ini 

$ vi /etc/odbcinst.ini
[FreeTDS]
Driver = /usr/lib64/libtdsodbc.so.0

odbc.ini 

$ vi /etc/odbc.ini
[sql1]
Driver = FreeTDS
Server = <SQL server 1 IP>
PORT = 1433
TDS_Version = 8.0
© 2001-2021 by Zabbix SIA. All rights reserved.
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
Trademark Policy