Re: osql: driver line incomplete

"James K. Lowden" <[email protected]> Tue, 10 May 2011 23:17:23 -0400

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<[email protected]>

On Mon, 9 May 2011 09:52:22 -0700
Dave Dumaresq <[email protected]> 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