[freetds] Problems Connecting Debian --> MSSQL through odbc

jklowden at schemamania.org jklowden at schemamania.org
Wed Jul 15 11:05:29 EDT 2009


Jaap van Arragon wrote:
> ###################################################
> echo     Driver          = FreeTDS \
> > | awk -F '[[:space:]]*=[[:space:]]*' '{print $2}'
> 
> Prints Nothing!
> ###################################################

For the shell script line:

	DRIVER=$(echo ${DRIVER_LINE} \
	| awk -F '[[:space:]]*=[[:space:]]*' '{print $2}')

sh -x echoes: 

> ++ echo Driver = FreeTDS
> ++ awk -F '[[:space:]]*=[[:space:]]*' '{print $2}'
> + DRIVER=

It's as though your awk doesn't accept Posix regular expressions as a field separator.  Is there any reason to think that could be so?  What does "awk --version" say?  

$ awk --version
GNU Awk 3.1.3
Copyright (C) 1989, 1991-2003 Free Software Foundation.


For the time being, you could replace 

	awk -F '[[:space:]]*=[[:space:]]*' '{print $2}')
with
	awk '{print $3}')

That's less general; it doesn't allow for a driver name with spaces in it.  But it should work in your case.  

Thanks for taking the time to help improve osql, Jaap.  The more often it works, the fewer questions people need to post to the list.  

Does /usr/lib/odbc/libtdsodbc.so actually exist?  

--jkl



More information about the FreeTDS mailing list