FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

On Fri, 5 Oct 2012 16:18:17 -0400
Todd Brush <brush.todd AT gmail.com> wrote:

> #cat /usr/local/etc/odbc.ini
> [NICKNAME]
> Driver=FreeTDS
> Description=mssql driver
> Server=hostname.dnssuffix.com
> Port=1433
> User=domain\username
> Password=password
> Database=DBNAME

http://www.freetds.org/userguide/odbcconnattr.htm

Please read that document again.  Some of what is in your odbc.ini is
not read by the driver; extra entries are silently ignored.  

Remember that specifying "Server" (not "Servername) in odbc.ini lets
the driver connect without reference to freetds.conf.  osql will show
you that.  

I suspect what's missing is the TDS version.  You don't say how you
configured FreeTDS or what kind of server you're connecting to.  If you
didn't change the defaults and you're connecting to a Microsoft server,
it won't work!  

Two other tools at your disposal: osql and TDSDUMP. 

HTH.  

--jkl