Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: jklowden AT schemamania.org
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problems Connecting Debian --> MSSQL through odbc
  • Date: Wed, 15 Jul 2009 11:05:29 -0400

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





Archive powered by MHonArc 2.6.24.

Top of Page