title: Data source name not found and no default driver specified - Zabbix
body: <p>I am trying to monitor an MSSQL database via ODBC with Zabbix, but I was getting an error that my DSN is invalid, even after performing several tests, does anyone have any idea what it could be?</p>
  <p>/etc/freetds.conf</p>
  <pre><code>[MSSQL_SERVER]
      host = &lt;ip&gt;
      port = 1433
      tds version = 8.0
  </code></pre>
  <p>/etc/odbcinst.ini</p>
  <pre><code>[FreeTDS]
  Description= FreeTDS Driver for Linux &amp; MSSQL
  Setup= /usr/lib64/libtdsodbc.so.0
  Driver = /usr/lib64/libtdsodbc.so.0
  UsageCount=1
  </code></pre>
  <p>/etc/odbc.ini</p>
  <pre><code>[MSSQL]
  Driver = FreeTDS
  Servername = MSSQL_SERVER
  </code></pre>
  <p>isql DSN</p>
  <pre><code>[root@zabbix]# isql MSSQL sa &lt;password&gt;
  +---------------------------------------+
  | Connected!                            |
  |                                       |
  | sql-statement                         |
  | help [tablename]                      |
  | quit                                  |
  |                                       |
  +---------------------------------------+
  SQL&gt; quit
  </code></pre>
  <p>tsql Servername</p>
  <pre><code>[root@zabbix]# tsql -S MSSQL_SERVER -U sa -P &lt;password&gt;
  locale is &quot;en_US.UTF-8&quot;
  locale charset is &quot;UTF-8&quot;
  using default charset &quot;UTF-8&quot;
  1&gt; quit
  </code></pre>
  <p>tsql conf</p>
  <pre><code>[root@zabbix]# tsql -C
  Compile-time settings (established with the &quot;configure&quot; script)
                              Version: freetds v1.1.20
               freetds.conf directory: /etc
       MS db-lib source compatibility: yes
          Sybase binary compatibility: yes
                        Thread safety: yes
                        iconv library: yes
                          TDS version: auto
                                iODBC: no
                             unixodbc: yes
                SSPI &quot;trusted&quot; logins: no
                             Kerberos: yes
                              OpenSSL: no
                               GnuTLS: yes
                                 MARS: yes
  </code></pre>
  <p>Error: <code>Cannot connect to ODBC DSN: [SQL_ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found and no default driver specified]</code></p>
  <p>Template:</p>
  <p><a href="https://i.stack.imgur.com/n9pEg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/n9pEg.png" alt="enter image description here" /></a></p>