Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-23862

Add ODBC setup page for official MSSQL UnixODBC drivers

XMLWordPrintable

      Steps to reproduce:

      1. Open https://www.zabbix.com/documentation/current/en/manual/config/items/itemtypes/odbc_checks/unixodbc_mssql
      2. Only FreeTDS option exists

      Result:
      FreeTDS is used as an only solution.

      Expected:

      • Connection string usage example from command line with isql and from item:
      #item key:
db.odbc.get["MSSQL example",,"Driver={ODBC Driver 18 for SQL Server};Server=127.0.0.1;Port=1433;UID=zbx_monitor;PWD=zbx_monitor_password;Encrypt=no"]
# command line:
isql -v -k "Driver={ODBC Driver 18 for SQL Server};Server=127.0.0.1;Port=1433;UID=zbx_monitor;PWD=zbx_monitor_password;Encrypt=no"

      Full list of MSSQL DSN and Connection String Keywords and Attributes:
      https://learn.microsoft.com/en-us/sql/connect/odbc/dsn-connection-string-attribute

      Driver setup:
      https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server

            zabbix.dev Zabbix Development Team
            edgar.akhmetshin Edgar Akhmetshin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: