title: "Adaptive Server is unavailable or does not exist" error connecting to SQL Server from PHP
body: <p>I'm attempting to connect to a SQL Server 2005 DB from my Mac using unixODBC and FreeTDS as I have outlined <a href="http://smgaweb.com/blog/connecting-remote-ms-sql-server-database-mac-os-x">here</a>. However, when I try to connect in to a different DB using the same setup, I get:</p>
  
  <pre><code>Connection Failed:[FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist.
  </code></pre>
  
  <p>Here is my freetds.conf setup:</p>
  
  <pre><code>[my_db]
  host = 12.34.56.789
  port = 1433
  tds version = 8.0
  </code></pre>
  
  <p>And here is my odbc.ini:</p>
  
  <pre><code>[my_dsn]
  Driver = /opt/local/lib/libtdsodbc.so
  Description = My Database
  Trace = no
  Servername = my_db
  Database = MyDB
  
  [ODBC Data Sources]
  my_dsn = FreeTDS
  </code></pre>
  
  <p>I am still able to connect to the other DB I set up on this computer (described in my blog post linked above), so I'm pretty sure that the error isn't on the Mac end. I've verified on the server that I'm using the correct IP address and port. Any thoughts on what could be the problem, and if it's on the server end?</p>