Ad Widget

Collapse

MsSQL by ODBC

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • xoxa
    Junior Member
    • Sep 2023
    • 6

    #1

    MsSQL by ODBC

    Hello, Guys.
    Im noob and i cant get any data from my MsSQL Server 2019 via Microsoft ODBC Driver 17 for SQL Server
    Im succefully getting answer from my MsSQL server when testing "SELECT name FROM sys.databases;" in Items (i see DBs, so its not driver, network or username), but when i mapping template "MsSQL by ODBC " to host - all items showing "no data"
    And yeah, my Zabbix Server 7.0 PRE-RELEASE​

    My configs:

    nano /etc/odbcinst.ini
    Code:
    [mssql]
    Description=Microsoft ODBC Driver 17 for SQL Server
    Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.10.so.4.1
    UsageCount=1​

    nano /etc/odbc.ini
    Code:
    [pervak]
    Driver = mssql
    Server = 192.168.88.232
    #TDS_Version = 8.0
    [vtoriak]
    Driver = mssql
    Server = 192.168.88.230
    ​
    In host i have
    ​​
    Last edited by xoxa; 08-09-2023, 11:02.
Working...