FreeTDS Development Group

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

On Mon, 9 May 2011 09:52:22 -0700
Dave Dumaresq <ddumaresq AT bccampus.ca> wrote:

> found driver named "/usr/local/freetds/lib/libtdsodbc.so"
> /usr/local/freetds/lib/libtdsodbc.so is an executable file
> Using ODBC-Combined strategy
> DSN [dsn_myvista] has servername "" (from /usr/local/unixODBC/etc/ 
> odbc.ini)
> 
> Right now, I have my server defined in freetds.conf  
> (Servername=freetds_dsn_myvista), does the above line indicate it's  
> expecting the server definition in odbc.ini?

No, that's a bug, thanks.  I committed a fix the CVS HEAD and to the
release candidate branch.  (The fix relies on the -F option of awk
(1) to accept a basic regular expression.  I hope that's OK with the
many awks out there.)

>       User=sa
>       Password=1234

These connection attributes are valid only in a connection string.  In
your odbc.ini file, the driver simply ignores them as noise.  Cf.
http://www.freetds.org/userguide/odbcconnattr.htm.  

HTH.

--jkl