title: FreeTDS working, but ODBC cannot connect
body: <p>I am trying to run connect to a MSSQL server from an Ubuntu 12.04 webserver with FreeTDS and unixODBC.</p>
  
  <p>Using tsql i can connect to the server with</p>
  
  <pre><code>~$ tsql -S dbs3 -U &lt;username&gt; -P &lt;password&gt;
  </code></pre>
  
  <p>No problem there.</p>
  
  <p>When I try to connect with isql however, I get the following error message:</p>
  
  <pre><code>~$ isql -v database3 &lt;username&gt; &lt;password&gt;
  [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
  [01000][unixODBC][FreeTDS][SQL Server]Unknown host machine name.
  [ISQL]ERROR: Could not SQLConnect
  </code></pre>
  
  <p>My config files are as follows:</p>
  
  <p>odbc.ini</p>
  
  <pre><code>[database3]
  Driver=FreeTDS
  TDS_Version=8.0
  Servername=dbs3
  Port=1433
  Database=benchmark_res
  </code></pre>
  
  <p>odbcinst.ini</p>
  
  <pre><code>[FreeTDS]
  Description=FreeTDS v0.91
  Driver=/usr/local/lib/libtdsodbc.so
  Setup=/usr/local/lib/libtdsS.so
  Trace=Yes
  TraceFile=/tmp/freetds.log
  ForceTrave=Yes
  UsageCount=1
  </code></pre>
  
  <p>freetds.conf</p>
  
  <pre><code># This file is installed by FreeTDS if no file by the same
  # name is found in the installation directory.
  #
  # For information about the layout of this file and its settings,
  # see the freetds.conf manpage "man freetds.conf".
  
  # Global settings are overridden by those in a database
  # server specific section
  [global]
      # TDS protocol version
  ;   tds version = 4.2
  
      # Whether to write a TDSDUMP file for diagnostic purposes
      # (setting this to /tmp is insecure on a multi-user system)
  ;   dump file = /tmp/freetds.log
  ;   debug flags = 0xffff
  
      # Command and connection timeouts
  ;   timeout = 10
  ;   connect timeout = 10
  
      # If you get out-of-memory errors, it may mean that your client
      # is trying to allocate a huge buffer for a TEXT field.
      # Try setting 'text size' to a more reasonable limit
      text size = 64512
  
  # A typical Sybase server
  [egServer50]
      host = symachine.domain.com
      port = 5000
      tds version = 5.0
  
  # A typical Microsoft server
  [egServer70]
      host = ntmachine.domain.com
      port = 1433
      tds version = 7.0
  
  [dbs3]
      host = &lt;server-ip&gt;
      port = 1433
      tds version = 8.0
  </code></pre>
  
  <p>I followed the installation guide 1. <a href="http://blog.mattwoodward.com/2012/08/freetds-quick-start.html" rel="noreferrer">here</a> and 2. <a href="http://blog.mattwoodward.com/2012/08/creating-datasource-with-freetds-and.html?showComment=1376395395571" rel="noreferrer">here</a></p>
  
  <p>Why isn't isql connecting properly?<br>
  My guess is that the mistake is super obvious but I'm just too stupid to see it :D</p>