[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