Ad Widget

Collapse

configure ODBC by MS SQL2017(Windows server 2012R2)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Lizerenoitez
    Junior Member
    • Jan 2021
    • 2

    #1

    configure ODBC by MS SQL2017(Windows server 2012R2)

    Hello.
    Help with setting up a template ODBC by MSSQL
    Zabbix 5.2 (debian 10)

    root@Zabbix:/var/log/zabbix# cat /etc/odbcinst.ini
    [ODBC Driver 17 for SQL Server]
    Description=Microsoft ODBC Driver 17 for SQL Server
    Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.6.so.1.1
    UsageCount=1


    Click image for larger version

Name:	Screenshot_1.jpg
Views:	580
Size:	66.6 KB
ID:	417593

    ERROR: Cannot connect to ODBC DSN: [SQL_ERROR]:[HY090][0][[unixODBC][Driver Manager]Invalid string or buffer length
  • salai
    Junior Member
    • Nov 2020
    • 27

    #2
    are you able to connect to the database using isql or sqlcmd?

    Comment

    Working...